How we can get unique records into one target table and
duplicate records into another target table??
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
can u give example for factless fact table
What is the use of an aggregator cache file?
what is degenerated dimension?
Difference between Target-based loading and constraint-based loading?
What the difference is between a database, a data warehouse and a data mart?
In informatics server which files are created during the session rums?
Define Pmrep command?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What is informatica? Why do we need it?
What is deployment group?
How to load data in informatica ?
Explain the types of transformations?
Can informatica load heterogeneous targets from heterogeneous sources?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
without table how to come first record only in oracle?