Different result sets (target data) w...

Different result sets (target data) while debugging and running the workflow??

Posted in the Informatica Forum



#1 Oct 16, 2013
I have a very basic knowledge of Informatica and I am stuck with one of the issues which I haven't been able to resolve in last 5-5 days.
Issue Description-
I have a workflow which retrieves data from a source xml file and then loads it into the target tables in an Oracle database after applying some business validations/rules (we have used look ups, filters, routers, aggregators etc to implement the business logic). Lately one of our business users reported that the target data seems to have some issues (some missing records) so i cross checked the mappings, made some changes and re ran the workflow. Strangely now the data seems to be loading correctly when I debug the workflow (by unchecking "Discard Target Data") whereas the records are still missing if i directly run the workflow. I aam not making any changes while debugging. Please can someone help me with this. Grateful if someone can suggest what to check for if this issue has already been faced in past.
PS: I am using Informatica Power Center designer 8.6.1
Abhishek Chauhan

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
Informatica Admin & Cloud Deployment (May '17) May '17 avi_infa 1
Converting row data to column data (Sep '16) 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