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
What are session parameters ? How do you set them?
What is joiner change?
Enlist the advantages of informatica.
Explain direct and indirect flat file loading (source file type) - informatica
Explain sessions?
How to elaborate powercenter integration service?
How to do unit testing in informatica? How to load data in informatica ?
update strategy transformation in informatica
What is the difference between informatics 7x and 8x and what is latest version?
How we can create indexes after completing the loan process?
how to load dimension table and fact table. plz tell me the steps.
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
How to start a workflow using pmcmd command?
What are the types of caches in lookup? Explain them.
Explain the mapping variable usage example in informatica