suppose if we have dublicate records in a table temp n now
i want to pass unique values to t1 n dublicat values to t2
in single mapping?how
Answer Posted / leo gilbert
Have a lookup to table T1 (should be dynamic one). If the
record already exists in T1 (i.e. duplicate) then route to
T2 else route to T1
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
What is a standalone command task?
my source is junk data how will u remove that junk data by using unix please any one replay me
How to create the source and target database connections in server manager?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Explain the difference between mapping parameter and mapping variable?
What do you mean by filter transformation?
How big was your fact table
What is the difference between router and filter?
Can we create multiple integration service on single repository?
what is INFORMATICA TESTING process
Under what conditions selecting sorted input in aggregator will still not boost session performance?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
How to use procedural logic inside infromatica?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.