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
- 19219 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
Explain incremental aggregation in informatica
What is domain in terms of informatica?
How many dimensions are there in informatica?
Differentiate between a repository server and a powerhouse?
What is a standalone command task?
What do you understand by SOA of Informatica?
Explain what are the different types of transformation available in informatica.
What is meant by target load plan?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What do you mean by worklet?
What are junk dimensions?
How can you define user defied event?
Tell me about Propagate functions in informatica
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What are the different components of powercenter?
