Hello
I have a DB2 connector stage as my target , its a simple Dataset to table load,
and i have the options as
Write mode: BulkLoad
Table Action : Append
Before/AfterSQL: No
Load Control :
LoadMode:Insert
Bulk Load with LOB or XML Columns : Yes
But for each run the table is getting truncated and loaded.
I have tried the other options also, For these options also its getting truncated and load
Write mode: BulkLoad
Table Action : Append
Before/AfterSQL: No
Load Control :
LoadMode:Replace
Bulk Load with LOB or XML Columns : Yes
Does Bulkload option in DB2 connector always Truncates and Load even if table action is Append and Load method is Insert ?
Db2 Connector Stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 152
- Joined: Mon Mar 07, 2011 6:16 am
Re: Db2 Connector Stage
Here table action you mentioned as Append. So the new records will be loaded into the table. No truncation will be occurred here.
If you mention table action is truncate then it will truncate the table then load
If you mention table action is truncate then it will truncate the table then load
Soumya
Re: Db2 Connector Stage
Yeah, But for the scenario where table action is append , write mode is Bulk Load and Load mode is replace, performs the similar opertaion as truncate and Load .
Why it happens like this.. what are the advantages of using this method instaed of truncate and load.
Why it happens like this.. what are the advantages of using this method instaed of truncate and load.