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
- 41271 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 big was your fact table
How you prepared reports for OLAP?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
Performance tuning in UNIX for informatica mappings?
What is session task and command task?
What is a joiner transformation?
What is the benefit of partitioning a session?
can we override a native sql query within informatica? Where do we do it? How do we do it?
Explain load alternative records / rows into multiple targets - informatica
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
How can we handle two sessions in informatica?
Differentiate between Load Manager and DTM?
What are the advantages of using informatica as an etl tool over teradata?
What is the function of union transformation?
Explain sessions. Explain how batches are used to combine executions?
