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
How do you take back up of repository?
Under what condition selecting sorted input in aggregator may fail the session?
Which means the first record should come as last record and last record should come as first record and load into the target file?
What is sequence generator transformation in informatica?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
what is the Default Source Option For Update Strategy Transformation?
waht type of interface is used for testing the data in informatica
How do you update the records with or without using update strategy?
can u give example for factless fact table
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
How to delete duplicate row using informatica?
How an expression transformation differs from aggregator transformation?
What is lookup transformation?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What are batches?