Interested to Buy Any Domain ? << Click Here >> for more details...
how eliminate the duplicates in flat file with out using
sorter ,aggregater
- 4 Answers
- 11451 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
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Please let me know how to make Data masking in informatica..
What are the new features of informatica 9.x in developer level?
What is the meaning of decode in informatica?
Briefly explain the aggregator transformation?
What you know about transaction control transformation?
Name the different lookup cache(s)?
What is an expression transformation in informatica?
What do you understand by SOA of Informatica?
What is the benefit of partitioning a session?
How to load the data from a flat file into the target where the source flat file name changes daily?
Why sorter is an active transformation?
How to create a non-reusable instance of reusable transformations?
Explain your project of banking domian.
Briefly define reusable transformation?
