Interested to Buy Any Domain ? << Click Here >> for more details...
suppose if we have dublicate records in a table temp n now
i want to pass unique values to t1 n dublicat values to t2
in single mapping using aggregator & router? how
- 7 Answers
- 13694 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / shalu
giving one example, lets say my table temp is having
following -
col1 col2
1 2
1 2
1 2
3 4
3 4
5 6
In the SQL Qualifier, override the query as
select col1,col2,count(1) total from temp group by col1,col2
which shows the output as
col1 col2 total
1 2 3
3 4 2
5 6 1
Now, use one router transformation where one condition is
where total >=1
and second condition where total>1
So first condition will return you all the unique records
1 2
3 4
5 6
and second condition will return you duplicate records
1 2
3 4
| Is This Answer Correct ? | 19 Yes | 5 No |
Post New Answer View All Answers
What are the different ways to implement parallel processing in informatica?
Mention few power centre client applications with their basic purpose?
What are the various types of transformation?
Explain lookup transformation source types in informatica
What is sq transformation?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What is exclusive and normal mode for repository services?
What is the use of source qualifier?
What do you understand by SOA of Informatica?
What is lookup transformation?
What are the static cache and dynamic cache in informatica?
What are the limitations of joiner transformation?
Differentiate between Load Manager and DTM?
Explain the difference between a data warehouse and a data mart?
Clarify the aggregator change?
