I have following requirement:
I have source file with 10 columns.
I need to split the file into target files to be used downstream dynamically based on the selective columns specified in a metadata table for the target files
Can you please let me know how this can be done in datastage.
Example:
Code: Select all
Source file: A.csv
empno, empname,age,telephone number,salary
Metadata Table 1:
Source file Source column
A.csv empno
empname
age
telephone
Salary
Metadata Table 2:
Source file Target File Target Column
A.csv X.csv empno
empname
A.csv Y.csv empno
age
salary
It need to be a generic job.