Informatica showing invalid source and Target Statistics. I dont find any reason why its showing like that.
When i loaded it in the target first time it showing and loaded data correctly in the DB.
used Update Strategy if there is any updation in the source- Tgt_Table_Update 0
When i execute the session second time it have to do updation actually. It does that job also perfectly.
Instead of 392 it showing the statistics 560. In my target i found the updated values with 392 records. which i was looking for.
Can anybody please say what will be the problem for this invalid statistics.
I am expecting that something wrong with the update operation.
Just check out your updated data is right or wrong. Your update key column is finding multiple rows for each row.
let us say your key column is "1" and your target has "1" repeated multiple times.
One possible reason, if there are pipeline partitions involved, the statistics looks incorrect but actually they are multitudes of actual results.
(Ex: If you use 3 partitions the results (aka total records loaded) are not divided by actual number of partitions but they will be multiplied by total number of partitions, 3 src recs -> 3 partitions -> 3 recs in target but stats looks like 9 recs ).
If this is not the possible case, post your mapping details in simple informatica format.
(SQ -> Ex-> FLT -> Updt-> TGT).
Let us know if it works ..
Looks like the SQL Trans count (total rows applied) are shows as 0 (earlier i thought this is an updt strategy for insert).
Troubleshoot using the following methods (unless you'vent tried yet) :
1. Remove update strategy from mapping, Write to target only for inserts. Check the rows inserted are appearing correctly.
2. Keep transformations upto router and write to a flat file target, check the statistics.
3. Check Session level properties (treat source rows --> Update as update ..etc)
Keep posted, If any of the above helps..
I not have a prblm either in SQL Transformation or Session level Properties. I have a prblm with update strtgy. Its treats one rows as four.. Could u please revert me back what will be prblm?
Are you using the target table as one of the source.My assumption is that in joiner ,it allowing both the source records (what is your join condition). Write the update flow into flatfile and see how many records are loading into the flatfile.
Please note : update startegy won't treat the rows as multiple row...
Yes am using my target table as one of the source. This is my join condition.
When i use look up transformation i am not facing the above issue. could u plz say how to resolve this problem by using joiner transformation itself.
Since you have selected the join type as full outer ,it is allowing both the source records to the target (source1 and source2(TGT) ) .Change the join type as Normal then you will get exact rows which is going for update.
I dont think so? How can i achieve my requirement by using normal join. When i execute the session first time the data is not getting loaded actually. When i choose full outer join only, the data is loaded.