How to extract original records at one target & Duplicate
records at one target?
Answer Posted / saradhi
As of my knowledge i think its possible by Router
Transformation.By writing one condition we can extract the
data with out duplication in one target then automatically
default records means with duplication are transferred in
to another target.
| Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
what is informatica metadata?
Explain Dataware house architecture .how data flow from intial to end?
Can u generate reports in Informatica?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
How to extract the informatica rejected data?
which one is better performance wise joiner or look up
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Differences between connected and unconnected lookup?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Tell me about MD5 functions in informatica
What are the differences between joiner transformation and source qualifier transformation?
What are session parameters ? How do you set them?
How might one distinguish in the case of mapping is right or not without associating session?
What is the need of an ETL tool?