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 happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
How to create or import flat file definition in to the warehouse designer?
tell me 5 session failure in real time how can you solve that in your project?
Mention few power centre client applications with their basic purpose?
Which means the first record should come as last record and last record should come as first record and load into the target file?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
Sequence generator, when you move from develoment to production how will you reset
How to load data in informatica ?
What are the different types of olap? Give an example?
Describe expression transformation?
Write the program through which the records can be updated?
How many types of sessions are there in informatica.please explain them?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What is InformaticaPowerCenter?
What all are steps in up gradation of Informatica server?