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.
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
Add your comments below
|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|
Find what you want!
Search Informatica Forum Now
Copyright © 2018 Topix LLC