Hi all,
I want to load 22 million records from a sequential file to a oracle table.
I design a job as
SeqentialFile ----->OracleTable
But when i run the job , sequential stage was not able to pick huge file which is more than 4 gig.
Please let me know whether we got any other alternate for this scenario
Regards
Sudha
22 Million Records from File to OracleEnterprizeStage
Moderators: chulett, rschirm, roy
Thanks a lot for your responce,
1)It was told that records will increase by 10% every year on 22 millions.accumalatively.
2)If I want to divide the file into smaller files how would i do it in the datastage.
The other thought is
a)Dividing the file into small files by using a unix script
b)There by using a folder stage pass all the files into the datastage job.
can any one help me on this thought.
1)It was told that records will increase by 10% every year on 22 millions.accumalatively.
2)If I want to divide the file into smaller files how would i do it in the datastage.
The other thought is
a)Dividing the file into small files by using a unix script
b)There by using a folder stage pass all the files into the datastage job.
can any one help me on this thought.
-
- Participant
- Posts: 135
- Joined: Tue Aug 14, 2007 4:27 am
- Location: Mumbai