I have a strange issue.
My source is a view. My target is a table..when i query select count(*) from view ..I am getting count as 5...but when i run the job ..monitor shows like records read from source(view) as 6..i dont understand why informatica is fetching 6 rows when i get count from the view in database as 5. i do not understand from
Where this extra record is coming from. there are NO sql override queries in source qualifier or at session level.
Could anyone please help me how to debug this from informatica end.