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
- 13871 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
Describe an informatica powercenter?
Can we change Dynamic to Static or Persistent cache? If so what happens?
What is the format of informatica objects in a repository?
Define mapplet?
What is a grid in Informatica?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
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)
Is it possible to define a single node as a Gateway node as well as worker node?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
Tell me about MD5 functions in informatica
if we have a delimiters at unwanted places in a flat file how can we over come those.
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What are the transformations that are not supported in mapplet?
How an expression transformation differs from aggregator transformation?
How many ways a relational source definition can be updated and what are they?
