Complex Flat File +Filler

Roopanwita · Post by **Roopanwita** » Fri May 16, 2008 1:42 am

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,

ArndW · Post by **ArndW** » Fri May 16, 2008 2:20 am

It is impossible to tell your structure from the post. The column "DELTA_FILE_BYTE" is something specific to your application.

Roopanwita · Post by **Roopanwita** » Fri May 16, 2008 3:18 am

Actully my question is ,do filler column in table has physical existance in table?

ArndW · Post by **ArndW** » Fri May 16, 2008 3:28 am

Yes, filler columns occupy actual space. They are columns just like any others.

Roopanwita · Post by **Roopanwita** » Fri May 16, 2008 3:55 am

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?

ArndW · Post by **ArndW** » Fri May 16, 2008 4:56 am

I have no idea what that column could be used for. Does it always have "A" or does it contain other value? "A" could mean "Add", "D"elete, "C"hange or "M"odify.

I have a COBOL file at this site with a column called "ADDRKENN", can you tell me if I need it and what it is used for?

ray.wurlod · Post by **ray.wurlod** » Fri May 16, 2008 7:13 am

You need it. It's the address of Ken N.

ArndW · Post by **ArndW** » Fri May 16, 2008 7:19 am

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.