dynamic Schema File
Posted: Tue Feb 23, 2010 7:58 pm
The job design looks like;
sequential file stage --> column import --> copy stage --> other stages
The input file is read in a single variable in sequential file stage. The column import regenerates other columns based on schema file.
currently there are 20 columns in the schema file in column generator stage. I added 5 additional columns in the schema file.
The intend was to process all the 25 columns with no changes to the job design.
can anyone please suggest me how can I achieve this.
Thanks
Mark
sequential file stage --> column import --> copy stage --> other stages
The input file is read in a single variable in sequential file stage. The column import regenerates other columns based on schema file.
currently there are 20 columns in the schema file in column generator stage. I added 5 additional columns in the schema file.
The intend was to process all the 25 columns with no changes to the job design.
can anyone please suggest me how can I achieve this.
Thanks
Mark