DSXchange

Hi, I need to create a parallel job that does an update or insert and in the case of update, I need to insert the old record into an audit table. My job is as follows (sorry - am not able to attach an image here) BeforeData(Oracle Stage O1) -> ChangeCapture (C1) AfterData (Oracle Stage O2) -> Change...

thanks to all for the wealth of info.

we will be doing physical deletes also and all this will be very useful.

1stpoint and Kenneth, Thanks for your replies. I will check if I am rebuilding the hashfile every time. Also, worktables was the first thing I thought of but creating worktables/temp tables is something our Admins frown upon and is only to be done if everthing else fails. I did create a job in PX wi...

Also wanted to mention that we do not want to use Dblinks.

I am not sure if PX lets you use dblinks..

Thanks but the 'not exists' won't be possible 'coz the tables are not on the same Database

I forgot to mention in my initial post that theTGT and SRC tables are on different Databases/Servers .

DataStage Version = 6 with PX O/S - AIX 5 Hi, We have a requirement where we basically need to do a logical delete of records from a target table (say table TGT) where records don't exist in a Source table (Table SRC). We already have a Server Job that creates a hashfile of the SRC records and uses ...

Hi, Datastage version 4.2 Database - Oracle 8.1.7 We need to lookup a big table (about 2 million rows) based on a free-text field - The source could also have upto or more than 2 million rows. Since creating a hashfile for the lookup table is not possible due to the free text field being 2000 chars ...

Hi, I've been having this strange problem - DataStage Director does not open - actually I am able to supply the login details and then it just hangs. I have to go to Windows Task Manager and end the task. No problem opening any of the other components like Manager, Designer, Administrator. However i...

I need to use an oracle packaged function to get the value of a field to be used in a transform . The input to the transform is a sequential file and the output is an OCI8 stage. The function will take 2 parameters (2 fields from the sequential file) and return a number which i need to populate a pa...

I need to call a Packaged Function in an Oci Stage which will be a lookup.
2 columns will be keys and the output of the function is the value I want to use in the transform.
How can this be done?
Any help is greatly appreciated.

Thanks

Hi, I have a job that takes records from a sequential file , does some basic transformations and then links to an OCI8 stage. In the OCI stage I want to call an Oracle STored procedure that will insert into multiple tables. I need to pass the the sequential file fields as parameters to this stored p...

Hi, I have a job that takes records from a sequential file , does some basic transformations and then links to an OCI8 stage. In the OCI stage I want to call an Oracle STored procedure that will insert into multiple tables. I need to pass the the sequential file fields as parameters to this stored p...