Informatica puts one row in the MySQL...

Informatica puts one row in the MySQL table

Posted in the Informatica Forum


United States

#1 May 16, 2007
I am using sqlServer as source and MySQL as the target. I tested a simple mapping read from SQL Server table of 40 rows and put it in the target MYSQL table. When I run the workflow it writes only one row. and on the next run it adds another one row.
Does any one have a soultion to my problem. I would appreciate your help.

Thanks in advance.
Amit Gupta

Noida, India

#2 May 18, 2007
Hi ,

is there any filter condition is applied on source ?

United States

#3 Jun 11, 2007
hey man... check you session configuration.. disable the option test load ..(you would have enabled it for 1 row..)

Thornhill, Canada

#5 Feb 11, 2011



Tell me when this thread is updated:

Subscribe Now Add to my Tracker

Add your comments below

Characters left: 4000

Please note by submitting this form you acknowledge that you have read the Terms of Service and the comment you are posting is in compliance with such terms. Be polite. Inappropriate posts may be removed by the moderator. Send us your feedback.

Informatica Discussions

Title Updated Last By Comments
Converting row data to column data Sep '16 Roopa 1
How to Handle Horizontal tab in Flat file in in... (Sep '15) Jul '16 ann_p 2
active and passive t/f (Feb '16) Jul '16 ann_p 2
Loading a specific Erwin model version into Met... (Apr '16) Apr '16 SCHJA26 1
not recognizing the source file (Jun '08) Mar '16 Jayashree 2
calling informatica powercentre workflow as a s... (Mar '16) Mar '16 anil 1
Update Records (Feb '16) Feb '16 beginer_informatica 1
More from around the web