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 aggregate cache in aggregator transformation?
Explain the use of aggregator cache file?
How to differentiate between the active and passive transformations?
What is a joiner transformation and why it is an active one?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Can we change Dynamic to Static or Persistent cache? If so what happens?
r u done any partitions in ur project?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
Quickly characterize reusable change?
What do you mean by worklet?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is a filter transformation?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is difference between a gateway node and worker node?
can u give example for factless fact table