DSXchange

I have the requirement to write a job which will run and read form any table given as parameter and will write it to a any table given as parameter.

So i have decided it to implement through RCP. RCP enabled in Datastage Admin and Job level also.

And is there any better way to implement this type of requirement.
Where the number of columns may get change according to table name.

Thanks.

Resist stupid requrements!

If you could do every transfer with the same DataStage job, there wouldn't be much work around, would there? There will be occasional differences (for example different databases' ways of handling BLOBs) that will require variations on your theme.