dynamic table structure support for DS job

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
gphukan
Participant
Posts: 2
Joined: Tue Feb 02, 2010 12:05 am
Location: Bangalore

dynamic table structure support for DS job

Post by gphukan »

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
ray.wurlod
Participant
Posts: 54595
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Re: dynamic table structure support for DS job

Post by ray.wurlod »

gphukan wrote: The following task should be done in single DS job.
Why?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
gphukan
Participant
Posts: 2
Joined: Tue Feb 02, 2010 12:05 am
Location: Bangalore

Post by gphukan »

Because we don't want to create intermediate tables/files to store interim
Post Reply