Thiru,
Basically this is simple one. Have you tried with all the loading options available.
I think "Replace exisitng rows completely" will work for you.
rajesh
Search found 67 matches
- Thu Jan 26, 2006 6:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how to update or insert
- Replies: 4
- Views: 1311
- Thu Jan 26, 2006 3:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Delete then insert records
- Replies: 4
- Views: 5393
Hello Babbu, Just create another instance of the same table for the delete action. Make sure that the inputs for insertion and deletion instances of the table comes from the same transformer. Also make sure that delete output from the transformer should be done first before the insert. Thanks, rajesh
- Wed Jan 25, 2006 9:18 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Audit / Run-Time Information in Datastage
- Replies: 7
- Views: 2916
Folks, Thanks a lot for all your inputs. Finaly I am able to get all the information. But coming to the no.of records inserted, no of records deleted or updated or rejected i think this information is not directly available. Do I need to generate my own code to caprture this? or is there any work ar...
- Wed Jan 25, 2006 8:00 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Reg Inter Process
- Replies: 2
- Views: 1128
Reg Inter Process
Folks,
Inter Process Plugin is only used for performance tuning or is there any other specific advantage of having this plug-in
Thanks,
Rajesh
Inter Process Plugin is only used for performance tuning or is there any other specific advantage of having this plug-in
Thanks,
Rajesh
- Wed Jan 25, 2006 4:03 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Universe Plugin
- Replies: 2
- Views: 982
Universe Plugin
Folks,
I see Universe Plugin in Database palette. can any one have any idea on wht this plug-in is?
Is Universe also a type of database like oracle, DB2.
Thanks,
rajesh
I see Universe Plugin in Database palette. can any one have any idea on wht this plug-in is?
Is Universe also a type of database like oracle, DB2.
Thanks,
rajesh
- Wed Jan 25, 2006 2:43 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Audit / Run-Time Information in Datastage
- Replies: 7
- Views: 2916
- Tue Jan 24, 2006 3:06 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Audit / Run-Time Information in Datastage
- Replies: 7
- Views: 2916
Audit / Run-Time Information in Datastage
Folks, Could any one let me know whether Datastage stores Audit / Run-Time information. If so Please let me know where can I get the information from. Wht I mean by Audit / Run - Time Information is, the information like Job(server -job) start time, no of records inserted, rejected, deleted, updated...