hi kirtan ,
today we started working with a mapping which is having 4 db2 sources conected to a sourcequalifier and thiss is a simple pass through mapping writing to a flat file but this mapping is running from one hour still we didnt get any records in source successeded rows in Run properties ,we are not gettting the reason,just i want to know how the informatica extracts the data from database and when it will show records in source successeded rows in run properties,what is the order of processing the data from transformation to transfermation
Comments feed
Hey Kirtan how have you been? I have a blog too now. Check it out I added yours to mine.
hi kirtan ,
today we started working with a mapping which is having 4 db2 sources conected to a sourcequalifier and thiss is a simple pass through mapping writing to a flat file but this mapping is running from one hour still we didnt get any records in source successeded rows in Run properties ,we are not gettting the reason,just i want to know how the informatica extracts the data from database and when it will show records in source successeded rows in run properties,what is the order of processing the data from transformation to transfermation
thanks in advance
subramanyam
subramanyam,
Have you tried running the source qualifier sql directly in the database? Can you make sure that you have required joins in the SQ?
Informatica runs the sql from source qualifier to the database and waits for the database to return the results.
Please provide the session log if it is possible for you.