How can we eliminate duplicate rows from flatfile,explain?
Answers were Sorted based on User's Feedback
Answer / nagaraj.g
using sorter transformation for distinct in a flat files
Is This Answer Correct ? | 16 Yes | 0 No |
Answer / 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 |
Answer / seshagiri
veere reddy,
Dynamic lookup will not work for flat file only static
lookup will work for a flat file
Is This Answer Correct ? | 2 Yes | 3 No |
Can you generate sequence numbers without using the sequence generator transformation?
Using Connected or unconnected lookup for performance wise which one is preferable?.
From where we can start or use pmcmd?
What is the difference between Bitmap and Btree index?
What is Micro Strategy? Why is it used for?
How will you check the bottle necks in informatica? From where do you start checking?
Define Update Override?
What is the filename which you need to configure in UNIX while installing infromatica?
what are the Methods For Creating Reusable Transformations?
how to convert 101 raja 101 raja sekar reddy 101 sekar----------> 101 reddy
What is difference between a gateway node and worker node?
what is diff b/t sorter t/r and agg have the option sorter property...