data insert issue

hargun · Post by **hargun** » Thu Jun 16, 2011 7:41 pm

hi.,

My jos update design is

seq file...........>Xfm......>odbcd(db2)

when i run the job and doing upsert(update only)

when the job run first it update but when it run again it update 0 records.

Job run fine without any error and warning.

could you please tell what would be the issue

Please reply.

ray.wurlod · Post by **ray.wurlod** » Thu Jun 16, 2011 8:48 pm

How do you know that the second run updated 0 records?

What were the row counts on each link on the second run?

Does the Transformer stage have a constraint expression? Was it the same source file on both runs?

SURA · Post by **SURA** » Thu Jun 16, 2011 8:50 pm

Information is not enough to help is my personal view.

DS User

hargun · Post by **hargun** » Fri Jun 17, 2011 4:40 pm

hi ray,

i check the target database from there and even log showing 0 records updated

DSXchange

data insert issue

data insert issue

Re: data insert issue