Split the Input Source into Multiple Datasets
Posted: Mon Sep 28, 2015 1:54 am
Hi All,
My requirement is to split the data in a table (80 - 100 fields) into multiple datasets at the target.
The target datasets should be created dynamically in the following way:
Dataset1 - 1 to 30 columns
Dataset2 - 31 to 60 columns
Dataset3 - 61 to 90 columns
Dataset4 - 91 to 100 columns.
We are not sure of the structure(metadata) of the input, and we are using RCP to read all the fields in datastage.
Any ideas are greatly appreciated.
Best Regards,
Sam
My requirement is to split the data in a table (80 - 100 fields) into multiple datasets at the target.
The target datasets should be created dynamically in the following way:
Dataset1 - 1 to 30 columns
Dataset2 - 31 to 60 columns
Dataset3 - 61 to 90 columns
Dataset4 - 91 to 100 columns.
We are not sure of the structure(metadata) of the input, and we are using RCP to read all the fields in datastage.
Any ideas are greatly appreciated.
Best Regards,
Sam