How to extract original records at one target & Duplicate
records at one target?
Answer Posted / krishnakanth.ch
yes... add a new column in the sql override by calculating
the count(*) to get how many times the record is repeating.
Using Router we can seperate them into two different
targets.
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
list out all the transformations which use cache?
How is union transformation utilized?
What are the data movement modes in informatica?
What are different types of transformations available in informatica?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What are the components of Informatica? And what is the purpose of each?
What is domain and gateway node?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What is a node in Informatica?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What are the types of schemas we have in data warehouse and what are the difference between them?
Performance tuning( what you did in performance tuning)
What are the measure objects?
What is the maplet?
write a query to retrieve the latest records from the table sorted by version(scd)