I have a requirement of creating generic jobs to read the COBOL file using CFF stage and do some basic transformations and load into Tera data. But unfortunately I am not able to use Schema files with CFF stage.
Currently I am using Sequential file to read the file using the schema files and RCP . But I am not sure to pass the transformation dynamically .
Here is an example of my transformation requirements.
Code: Select all
Input Column Names :
1. COLUMN1
2. COLUMN2
3. COLUMN3
4. COLUMN4
4. COLUMN4_NULL_IND
And Output Column Names :
1. COLUMN1
2. COLUMN2
3. COLUMN3
4. If IsNull(COLUMN4_NULL_IND) Then SetNull() Else COLUMN4
And for each each file the column names differs.
Many Thanks,
Anand