Hi,
i have a situation where i have 2 input files which have to be loaded into same target table. The difference between the two delimited files is that one has about 5 columns and the other has 8 columns. The first 5 columns of both are same. I want to use the same job to load data from both these files. Documentation says that we can pad missing columns with SQL NULL or pad them with a character specified, but couldnt implement it. (this functionality is sort of similar to the trailing null cols concept of sqlldr)
Has another done that before. Please suggest how to get it done.
thanks
missing column action in sequential file stage
Moderators: chulett, rschirm, roy
Your approach sounds to me like it should work fine. What did you actually use in the 'extra' columns in the Sequential stage?
Scroll right over to the "Incomplete Column" column and change it for all of those affected columns to "Replace" and it should set them to null by default when loading the file where they are 'missing'.
Scroll right over to the "Incomplete Column" column and change it for all of those affected columns to "Replace" and it should set them to null by default when loading the file where they are 'missing'.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers