how to do the bulk loading in Dataset in datastage

deesh · Post by **deesh** » Wed Dec 05, 2012 3:16 am

Hi,

we have a scenario like need to populate 2 million records , i need to pass the records at a time 40,000.

jerome_rajan · Post by **jerome_rajan** » Wed Dec 05, 2012 4:35 am

Bulk loading is a database specific concept. Datasets reside on the same server as Infosphere. Whatever data is available is written to the dataset's data files.

ArndW · Post by **ArndW** » Wed Dec 05, 2012 4:59 am

There is only 1 way to populate a dataset - from a DataStage job using the dataset stage. One can copy or dump from a dataset using "orchadmin" from the command line.