View previous topic :: View next topic
|
Author |
Message |
murugan_mf
Active User
Joined: 31 Jan 2008 Posts: 148 Location: Chennai, India
|
|
|
|
Hi,
I have a daily job which needs to delete records from teradata table before loading the table everyday.
Through MLOAD we can load data to teradata table.Is it possible to wipe out the records in the table before loading with new records.
Thanx in advance for ur reply.
Thanks!
Murugan.l |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
Hi,
I'm not a Dataware House guy, however this is what I got after surfing the net a little:
Quote: |
We just drop and recreate the staging table every time. We keep a pristine version of the table with zero rows called xxx_staging_tmpl(template). So after the table is dropped we just do a CTAS from template. Just make sure that the staging table you create is multiset and the same primary key as the template table. |
Quote: |
In informatica, you can create multiple Mload connections like
Insert Mload
Update Mload
Delete Mload
Upsert Mload
If you wanna delete records from table, use Delete Mload, Truncate option will be disabled, if you use external loaders. |
PS. Today work-load is lil less.. |
|
Back to top |
|
|
murugan_mf
Active User
Joined: 31 Jan 2008 Posts: 148 Location: Chennai, India
|
|
|
|
Thanx anuj.But i dont know Delete Mload is possible in teradata. |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
Hi,
Search on "mload scripts + delete" in Google. |
|
Back to top |
|
|
murugan_mf
Active User
Joined: 31 Jan 2008 Posts: 148 Location: Chennai, India
|
|
|
|
Anuj i checked in the manual and i could find the syntax for Delete MLOAD.Thanks again! |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
Great, Hopefully syntax will be implemented successfully.
Have a Great weekend & Happy Diwali...
-Ad |
|
Back to top |
|
|
murugan_mf
Active User
Joined: 31 Jan 2008 Posts: 148 Location: Chennai, India
|
|
|
|
Happy Diwali |
|
Back to top |
|
|
dharmendra_kp
New User
Joined: 10 Mar 2005 Posts: 33 Location: Lewiston
|
|
|
|
I gues load process transfers data from file (PS) to table. So in order to delete the table containt can we load an empty file? That is how we delete data DB2 tables. |
|
Back to top |
|
|
|