Hi
If i had source like unique & duplicate records like 1,1,2,3,3,4
then i want load unique records in one target like 2,4 and i want
load duplicate records like 1,1,3,3 then can any body please send
me what is th scnario. my mail i
shek.inform@gmail.com
Answer Posted / suman chattopadhyay
Shirish,
Part 1 of your answer is not correct. If you use distinct
option in sorter you will get all the distinct values even
for the duplicate. i.e if the values are 1,1,2,3,3,4, you
will get 1,2,3,4 in target.
Part 2 of your answer will do all the trick for duplicate
and unique ones. If you use group by and count the number
of occurences you will get 1 as the count for unique values
and more than one as count for duplicate values. Pass those
records with count 1 to 1 target and the other to the 2nd
target.
Hope this helps.
Suman
Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
can we override a native sql query within informatica? Where do we do it? How do we do it?
Enlist the various types of transformations.
what is size of u r database?
What do think which one is the better joiner or look up?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
Describe the impact of several join conditions and join order in a joiner transformation?
Design a mapping to load a target table with the following values from the above source?
What is an unconnected transformation?
What are the transformations that are not supported in mapplet?
Explain lookup transformation in informatica
Informatica settings are available in which file?
What are the static cache and dynamic cache in informatica?
What differs when we choose the sorted input for aggregator transformation?
what is Active lock explain
In warehouses how many schemas are there?