inserting rows into target not allowed

Formally known as "Mercator Inside Integrator 6.7", DataStage TX enables high-volume, complex transactions without the need for additional coding.

Moderators: chulett, rschirm

Post Reply
sunitha_cts
Participant
Posts: 98
Joined: Thu Feb 05, 2009 1:14 am
Location: visakhapatnam
Contact:
Contact sunitha_cts

inserting rows into target not allowed

Post 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
Top
Pagadrai
Participant
Posts: 111
Joined: Fri Dec 31, 2004 1:16 am
Location: Chennai

Re: inserting rows into target not allowed

Post 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 ?
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

Are you using WebSphere Transformation Extender (TX)? If not, please don't post in the TX forum.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Nice, two posts today and both in equally wrong (but different) forums.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage TX”