Hi,
I have a csv file which can have 60 to 105 columns .
Eg.one day it will have 60 columns,next day it will have 78 columns and so on.
How should i load this file into Oracle database
Regards
Shadab
Files with varying columns
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 21
- Joined: Tue Apr 24, 2007 12:39 am
Files with varying columns
Last edited by Shadab_Farooque on Mon Jul 14, 2008 4:47 pm, edited 1 time in total.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 21
- Joined: Tue Apr 24, 2007 12:39 am
-
- Participant
- Posts: 21
- Joined: Tue Apr 24, 2007 12:39 am
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
check this post :
viewtopic.php?p=291072
viewtopic.php?p=291072
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Not 100% sure whether that's true or not, but if it is you can put the Sequential File stage into a server Shared Container to make use of this particular functionality in a parallel job.
You might also investigate an approach using the Schema File property of the parallel Sequential File stage.
You might also investigate an approach using the Schema File property of the parallel Sequential File stage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.