dynamic table structure support for DS job
Posted: Tue Feb 02, 2010 2:09 am
Hi,
Here is my requirement
We are not sure of few columns drops and addition into source file and destination table. The following task should be done in single DS job.
1. We want to load the source file and on the fly we want to do some mapping for few columns from other existing table(We know the column names to be mapped.)
2. After all processing we want to load the data into destination table.
I have tried to use RCP but it does not support DOUBLE and INTEGER types as column. Is there any way to tackle this issue.
Thanks in advance
Here is my requirement
We are not sure of few columns drops and addition into source file and destination table. The following task should be done in single DS job.
1. We want to load the source file and on the fly we want to do some mapping for few columns from other existing table(We know the column names to be mapped.)
2. After all processing we want to load the data into destination table.
I have tried to use RCP but it does not support DOUBLE and INTEGER types as column. Is there any way to tackle this issue.
Thanks in advance