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
What is a repository? And how to add it in an informatica client?
Briefly explain the aggregator transformation?
What if the source is a flat-file?
What is depict expression change?
Scheduling properties,whats the default (sequential)
What are the advantages of informatica?
Which version configuration tool used in ur project?
What is the session task and command task?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
How an expression transformation differs from aggregator transformation?
What is deployment group?
Define filter transformation?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What is meant by incremental aggregation?
Explain the informatica workflow?