Hi,
In one job we r loading from complex flat file to Oracle stage.CFF stage is of 1000byte,so I am using a Filler Column.There is also one more column "Delta" ..same colum is getting populated in target.
Do these columns are actual column.? do they have physical existance in table?
or While loading new table they can be ignored?
Thanks,
Complex Flat File +Filler
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 125
- Joined: Mon Sep 11, 2006 4:22 am
- Location: India
Complex Flat File +Filler
Last edited by Roopanwita on Thu Jun 19, 2008 10:09 pm, edited 2 times in total.
-
- Participant
- Posts: 125
- Joined: Mon Sep 11, 2006 4:22 am
- Location: India
-
- Participant
- Posts: 125
- Joined: Mon Sep 11, 2006 4:22 am
- Location: India
Filler column is used to add space to make line length 1000 or 2000 byte.
In file (while loading from CCF to ORACLE stage) there is one more default column DELTA CHARACTER(1) . and value of that column is 'X'
Can you please tell me what is the use of that column?
In file (while loading from CCF to ORACLE stage) there is one more default column DELTA CHARACTER(1) . and value of that column is 'X'
Can you please tell me what is the use of that column?
Last edited by Roopanwita on Thu Jun 19, 2008 10:08 pm, edited 1 time in total.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Ray - I'll take that advice under advisement :D Now, you need to go back and tell Roopanwita what his delta blues column contains.
Roopanwita - We might be joking around a bit here, but remember that we cannot know your data descriptions and the column is not a reserved word or name in any system we are aware of.
Roopanwita - We might be joking around a bit here, but remember that we cannot know your data descriptions and the column is not a reserved word or name in any system we are aware of.