How can we eliminate duplicate rows from flatfile,explain?
Answer Posted / veera reddy
By Using Aggregator transformation by selcting the group by
option or using sorter by using distinct option or by using
dynamic lookup by selecting distinct option.
Is This Answer Correct ? | 6 Yes | 5 No |
Post New Answer View All Answers
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What are the advantages of using informatica as an etl tool over teradata?
Explain pushdown optimization and types in informatica
can u any challenge your project?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Explain the different lookup methods used in informatica?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
How to load last n records of file into target table - informatica
Under what condition selecting sorted input in aggregator may fail the session?
Explain the shared cache and re-cache?
tell me 5 session failure in real time how can you solve that in your project?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What is the function of look up transformation?
Differentiate between a repository server and a powerhouse?
Can u generate reports in Informatica?