how can u avoid duplicate rows in flat file?
Answers were Sorted based on User's Feedback
Answer / sunil
In a sorter transformation select distinct option to avoid
duplicates in a flat file
Is This Answer Correct ? | 11 Yes | 0 No |
Answer / ramanaiah
without using sorter,and aggregrator transformations.we can
useing dynamic lookup to avoid duplicate rows.
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / sbvp
i also faced this question . i said that i am using sorter
and agg group by options. but they ask me again with out
using sorter and agg how can u eliminate the duplicates? so
, plz give me a answer for that
Is This Answer Correct ? | 0 Yes | 0 No |
to improve the performance of aggregator we use sorted input option and use sorter t/r befor aggregator. But here we are increasing one more cache in our mapping i.e; sorter. So how can u convince that you are increasing the performance.?
explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
where to store informatica rejected data?
i have a source of n records.i have to load n+5 records to my target.What is the procedure??????plz tell me.....
HOE DO U IMPLIMENT SCHEDULING IN INFORMATICA?
what is the look up transformation?
State the differences between sql override and lookup override?
What are the different caches used in informatica?
How to calculate the cache size if say we are doing a performance check on a mapping and found that a particular cache needs to be changed. Is there a formula to calculate this! i know that informatica has a auto option available but how to calculate manually?
What is a diff between joiner and lookup transformation
16 Answers CTS, Satyam, TCS, UHG,
how did u understand business requirement?