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
- 19332 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
How might one distinguish in the case of mapping is right or not without associating session?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What are the differences between a connected lookup and unconnected lookup?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
Have you worked with/created Parameter file
What are the new features of informatica 9.x in developer level?
What is status code in informatica?
What do you mean incremental aggregation?
Whats there in global repository
Name the different lookup cache(s)?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What could be the possible resons of locks by user?
What is the meaning of decode in informatica?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Why union transformation is an active transformation?
