how eliminate the duplicates in flat file with out using
sorter ,aggregater
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
have u done any performance tuning? how u ll do?
Write the different tools in the workflow manager?
what is the -ve test case in your project.
is it possible to index the data in cache of lkp transformation ?
Performance tuning( what you did in performance tuning)
What is a stored procedure transformation?
What is the difference between a connected look up and unconnected lookup?
Write the prerequisite tasks to achieve the session partition?
what is the Default Source Option For Update Strategy Transformation?
What is aggregate cache in aggregator transformation?
Design time, run time. If you don't create parameter what will happen
Explain what transformation and how many are there in informatica?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What is a snowflake schema?
How do you remove duplicate records in informatica? And how many ways are there to do it?