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
- 19342 Views
- HCL, Schneider, I also Faced
- E-Mail Answers
Answer Posted / shridhar kasat
For Unique and Duplicate , we can go for same flow :
Source-->SrcQualifier-->Aggregator(group
by this column and find count also)--> then use joiner (use
the column from Source qualifier and join the data from
Aggregator as source qualifier.col=aggregator.col) -->
Router (insert into t1 for count>1 and for count=1 insert
into t2). t1 is for duplicate records and it will cintain
1,1,3,3 and t2 will have 2,4.
Records in Source Q :
col
1,1,2,3,3,4
The records after agregator will look like this :
col count
1 2
2 1
3 2
4 1
Records after Joiner : source q.col=aggregator.col
col count
1 2
1 2
2 1
3 2
3 2
4 1
These records will flow in router and we define two groups;
one for count>1 (for duplicates record) and second for
count=1 ( for unique record)
Hope this answer suffice your requirements.
Regards
Shri
| Is This Answer Correct ? | 23 Yes | 0 No |
Post New Answer View All Answers
What are the different transaction levels available in transaction control transformation?
What are the different types of olap? Give an example?
What are the differences between source qualifier and joiner transformation?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
can we override a native sql query within informatica? Where do we do it?
What is a router transformation?
Explain lookup transformation is active in informatica
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What is the difference between a connected look up and unconnected lookup?
How to join three sources using joiner?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What are the limitations of joiner transformation?
How to call shell scripts from informatica?
What are the various types of transformation?
What are the new features of informatica 9.x in developer level?
