DSXchange

If we use 2 DTS stages, can we use same work queue for both. In case of job failure, do you know how the roll back and replay will happen if we use 2 DTS stages?

Your help of this is much appreciated.

Thanks

Thanks Ray for your immediate reply. I think your are talking about the Sequence jobs.In sequence jobs, this SDK key managent routines are there under trigger options. But I think that is for conditions for the sequence to run successfully. Actually what I want to do is to load the sequence number o...

Hi, I need to create a unique sequence number for a job. If I run the job at a particular instant of time say today, it should have a sequence number and if I run the same job again after some time say tomorrow, then it should have a new sequence number. Do anybody have any idea how to create the se...

Thanks to everyone for such a fast reply. I have to use two target DB2 stages since I have to load two tables. As sugeested by asita, the child table cannot be loaded before the parent table since the primary key in parent table is the foreign key in child table. Besides transaction size, there is o...

Not loaded properly means sometimes some of the records will be loaded in child table and some of them are not. If a date field is there in the record, then because of incompatibilty, it is not loaded into the child table.

Not loaded properly means sometimes some of the records will be loaded in child table and some of them are not. If a date field is there in the record, then because of incompatibilty, it is not loaded into the child table.

I have a job in which I have to load two tables into the database. The two tables have parent child relatonship.I have a sequential file as input stage and then a transformer stage and finally I have to split the input record into two tables and load into the database as two different tables. I am u...