Loading files into Oracle tables
Posted: Fri Mar 25, 2011 10:42 am
Hi,
I have 150 files (text) as source. I need to load 150 files data into 150 Oracle tables. Without any changes for columns order and data types.
Every file has different number of columns. Delimiter is same (^) for all the files.
I need to load 150 files data into 150 tables every day and simultaneously
File1 --------- Table1
File2 ------- Table2
File3 ------- Table4
My approach is I have to develop 150 Datastage jobs for loading 150 tables.
Instead of developing 150 jobs, is there any solution in datastage that can load 150 tables simultaneously (From 150 files).
If there is no solution in datastage , is there any other way to solve this issue?
If you have any solution, can you please explain me.
Thanks
Srini
I have 150 files (text) as source. I need to load 150 files data into 150 Oracle tables. Without any changes for columns order and data types.
Every file has different number of columns. Delimiter is same (^) for all the files.
I need to load 150 files data into 150 tables every day and simultaneously
File1 --------- Table1
File2 ------- Table2
File3 ------- Table4
My approach is I have to develop 150 Datastage jobs for loading 150 tables.
Instead of developing 150 jobs, is there any solution in datastage that can load 150 tables simultaneously (From 150 files).
If there is no solution in datastage , is there any other way to solve this issue?
If you have any solution, can you please explain me.
Thanks
Srini