How to extract original records at one target & Duplicate
records at one target?
- 12 Answers
- 19670 Views
- I also Faced
- E-Mail Answers
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
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What is expression transformation?
What is the session task and command task?
What are the limitations of joiner transformation?
What are the issues you have faced in your project? How did you overcome those issues?
how to create user defined function (udf) in informatica
What is a shortcut and copy in Informatica and how two are different with each other?
my source is junk data how will u remove that junk data by using unix please any one replay me
What is target load order?
What is an expression transformation?
Write the advantages of partitioning a session?
Have you worked with/created Parameter file
Explain informatica architecture - version 8 / 9
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What are the new features of Power Center 5.0?
