How many ways are there to do 'remove duplicate records in informatica'?
No Answer is Posted For this Question
Be the First to Post Answer
What are the options in the target session of update strategy transsformatioin?
get me output as if input is like 1 x o/p-->1 x,y,z 1 y 2 a,b 1 z 3 c 2 a 2 b 3 c
Insert else update option in which situation we will use
When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?
what is threshold error in informatica?
What is the benefit of partitioning a session?
Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..
Differentiate between reusable transformation and mapplet.
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
which is better perfomancewise lookup or joiner and why?can anyone give example?
How mapping parameter and variable works
how can we check whether a particular cache is static or dynamic?