how can u avoid duplicate rows in flat file?
Answer Posted / 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 |
Post New Answer View All Answers
What does update strategy mean, and what are the different option of it?
Performance tuning( what you did in performance tuning)
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is informatica metadata and where is it stored?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What is a passive transformation?
What is difference between a gateway node and worker node?
What are the tasks that can be performed using sq?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What are the steps involved in the migration from older version to newer version of Informatica Server?
Make a note of the quantity vaults made in informatica?
How do you change a non-reusable transformation to reusable transformation?
Differentiate between Load Manager and DTM?
Briefly define reusable transformation?
What are the uses of etl tools?