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
What is the function of union transformation?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
Explain sessions and how many types of sessions are there?
define galaxy repository in informatica
can anyone suggest best free Talend data integration training online
What is confirmed fact in dataware housing?
Tell me about Propagate functions in informatica
Tell me about MD5 functions in informatica
What are the data movement modes in informatica?
What is parallel processing in informatica?
What are batches?
Explain what are the different versions of informatica?
How to update a particular record in target with out running whole workflow?
scenario where i can use only concurrent execution of workflow.
What is union transformation?