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
Explain the informatica workflow?
What are the types of caches in lookup?
what are factless facts? And in which scenario will you use such kinds of fact tables.
Enlist the tasks for which source qualifier transformation is used.
Repository user profiles
What is event and what are the tasks related to it?
How can we update a record in the target table without using update strategy?
What is aggregate cache in aggregator transformation?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
Different circumstance which drives informatica server to expel records?
What is an aggregator transformation?
How to generate sequence numbers using expression transformation?
What is olap (on-line analytical processing?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
Differences between version 7.x and 8.x.