DB2 Connector Truncate & Bulk Load Option
Posted: Tue Oct 04, 2016 10:05 am
Hi All,
I have a requirement in my project to refresh the data in 10 DB2 tables ( volume is around 80 million) and load the fresh records into it.
I am planning to go with the following options in the DB2 connector stage,
Write Mode : BulkLoad
Table Action : Replace
Record Count : 2000
Array Size : 2000
Can you pls let me know whether this is the correct way to do this.
Thanks
Freddie
I have a requirement in my project to refresh the data in 10 DB2 tables ( volume is around 80 million) and load the fresh records into it.
I am planning to go with the following options in the DB2 connector stage,
Write Mode : BulkLoad
Table Action : Replace
Record Count : 2000
Array Size : 2000
Can you pls let me know whether this is the correct way to do this.
Thanks
Freddie