Interested to Buy Any Domain ? << Click Here >> for more details...
How we can get unique records into one target table and
duplicate records into another target table??
- 11 Answers
- 41688 Views
- Deloitte, IBM, iGate, I also Faced
- E-Mail Answers
Answer Posted / amedela chandra sekhar
sq-->Aggregator-->Router-->target
select group by for port name empno
in aggregater t/r take 1 output port and give condition like
select group by for port name empno
varcount---->count(*)
connect this one router and in router take 2 groups and
give condition like
uniqe_record :varcount=1-----for unique
duplicate_record :varcount>1 ----for duplicate
and connect that groups to target.
u will get result.
| Is This Answer Correct ? | 7 Yes | 10 No |
Post New Answer View All Answers
How do you manage the Parameter files while migrating your data from one environment to another environment?
What are the components of workflow manager?
Mention few advantages of router transformation over filter transformation.
When do you use sql override in a lookup transformation?
What are the different clients of powercenter?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
update strategy transformation in informatica
What are the types of schemas we have in data warehouse.
Explain pmcmd command usage in informatica
permutations of mapplet
What is the function of aggregator transformation?
Describe expression transformation?
What are the uses of etl tools?
What is the function of look up transformation?
can you please explain me pre session and post session options?
