Job Design in DS EE

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
vivekjv
Participant
Posts: 14
Joined: Thu Oct 13, 2005 4:28 am

Job Design in DS EE

Post by vivekjv »

Hi,

I am designing a job to extract data from an Oracle table, perform a lookup using a Teradata table and finally load into the same Teradata table.

The job seems to be working fine but is it a good practice to follow this approach? Does Datastage EE enforce the transactional integrity at the table level by making use of locks? Finally in case the former being true, is it possible to make use of the same table as a source and target with the necessary transformations in between?
Vivek

There are things known and there are things unknown, in between them are the doors.
Top
gssr
Participant
Posts: 243
Joined: Fri Jan 09, 2009 12:51 am
Location: India

Post by gssr »

Already Discussed here...

This may be useful,

viewtopic.php?t=131544&highlight=source ... same+table
RAJ
Top
vivekjv
Participant
Posts: 14
Joined: Thu Oct 13, 2005 4:28 am

Post by vivekjv »

Hi,

Thank you very much for the info!
Vivek

There are things known and there are things unknown, in between them are the doors.
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”