Data checking for Siebel import

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
gerald.d.hoang@disney.com
Participant
Posts: 1
Joined: Tue Nov 01, 2005 9:13 am

Data checking for Siebel import

Post by gerald.d.hoang@disney.com »

Hi everyone:
I am creating DS jobs to import (upsert) data to Siebel database using DS Siebel connector. I'd like to know if there is a way in DS to determine/write out (to a seq file/table) whether records were processed into Siebel tables successfully. Currently, I am joining between the source data coming in, and the data imported to Siebel Base table. Those not found in Siebel were marked as 'not imported'. I'd just wonder if there is a better way to perform this auditing? Thanks-

Regards,
Jerry
jdh_cfl
Post Reply