Interested to Buy Any Domain ? << Click Here >> for more details...
how eliminate the duplicates in flat file with out using
sorter ,aggregater
- 4 Answers
- 11086 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / kish
Hi Krishna,
i think you r wrong...he is asking abt flat file...
by using LOOKUP we can eliminate duplicates...
You can eliminate duplicates and can capture that duplicates
using
dynamic lookup cache. look up the target table if New lookup
row=0 then it is unchanged (duplicate
record) SEND TO ONE TARGET
| Is This Answer Correct ? | 17 Yes | 0 No |
Post New Answer View All Answers
On which transformations you created partitions in your project?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What are the types of caches in lookup? Explain them.
Design time, run time. If you don't create parameter what will happen
How we can create indexes after completing the load process?
How to elaborate tracing level?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Why is sorter an active transformation?
can u give example for factless fact table
can we override a native sql query within informatica? Where do we do it? How do we do it?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
How to use procedural logic inside infromatica?
Difference between Data and Index Caches?
my source is junk data how will u remove that junk data by using unix please any one replay me
