Page 1 of 1

inserting rows into target not allowed

Posted: Tue Apr 21, 2009 12:19 am
by sunitha_cts
Hi ,

I am using oracle stage AS TARGET and i used all the transformation rules but i am not able TO INSERT RECORDS INTO THE TARGET TABLE.I am getting records insert 0.Can anyone give me the remedy .

Thanks
Sunitha

Re: inserting rows into target not allowed

Posted: Tue Apr 21, 2009 12:55 am
by Pagadrai
Hi Sunitha

are you using Upsert mode ?
Check the key columns you have mentioned in Oracle stage and the keys in the oracle database.
Are any records getting updated or so you see any warnings in the job log ?

Posted: Tue Apr 21, 2009 3:03 am
by ray.wurlod
Are you using WebSphere Transformation Extender (TX)? If not, please don't post in the TX forum.

Posted: Tue Apr 21, 2009 7:02 am
by chulett
Nice, two posts today and both in equally wrong (but different) forums.