How to extract original records at one target & Duplicate
records at one target?
Answers were Sorted based on User's Feedback
Answer / rag
Hi You can do this another way also
put the expresession transforamtion and read some previous
record with the currect record or any unique column value in
the expression and if they are equal then assign the
flag(means duplicate flag) else
assign the new flage.
pass the duplicate flag records to the filter and goes to
the TB(duplicate records target) and unique values to the
origonal target
| Is This Answer Correct ? | 0 Yes | 2 No |
Answer / 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 |
How to get EVEN & ODD numbers separately?
What is the functionality of update strategy?
what is the logic will you implement to laod the data in to one factv from 'n' number of dimension?
how can u approach u r client
I am using Informatica 7.1.1. and i used emails task for getting emails but not able to get emails is there any settings in Informatica installation level?
What is a router transformation?
Which is better performance wise database or file?How?
How can i set break points in debugging mode ? can explain steps please?
What are the different threads in DTM process?
wat s mapping parameter and mapping variable? how do you set that in a mapping?
how to run the batch using pmcmd command
Dovelopment work (mapings,workflows)and unit testing also done in informatica ,then wt we do ? pls give me detail?