Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6 Answers
- 19323 Views
- HCL, Schneider, I also Faced
- E-Mail Answers
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
Why do you use Mapping Parameter and mapping variable?
What does update strategy mean, and what are the different option of it?
What are the databases that informatica can connect to windows?
What is the fact table?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is a filter transformation?
What is enterprise data warehousing?
What is a dimensional model?
Define pmcmd command?
What is the benefit of partitioning a session?
How do you change a non-reusable transformation to reusable transformation?
Describe an informatica powercenter?
How to implement security measures using repository manager?
What is the function of union transformation?
What is the format of informatica objects in a repository?
