Datasets and Keys

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
StefanFrost
Participant
Posts: 6
Joined: Mon Nov 14, 2005 8:38 am

Datasets and Keys

Post by StefanFrost »

I am trying to build a generic parallell job using RCP which deletes or updates records in a database table using a dataset as a source. The tables consist of the same columns as the incoming dataset so RCP seems like a great idea, however all sources have different keys and the dataset schema-file doesn't seem to save key information! Therefore a update or delete cannot be preformed on the target table. I've tried to specify keys however the job crashes if a column is not in the dataset! So I don't know if I can build a generic job, could someone help me?
----------------------------------------
ETL/DW-Desiger/Developer
Special interest in ETL-optimization
Quality/Validity and Structure.
----------------------------------------
Post Reply