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
inserting rows into target not allowed
-
- Participant
- Posts: 98
- Joined: Thu Feb 05, 2009 1:14 am
- Location: visakhapatnam
- Contact:
Re: inserting rows into target not allowed
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 ?
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 ?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: