How we can get unique records into one target table and
duplicate records into another target table??
Answer Posted / chetan
I/p
A
B
B
C
D
D
need to load A.C in one tgt and B,B,D,D in another target table.
SQ o/p should be given to aggregator. group by first column.create another port(v_count) with count(*).
SQ o/p should be passed to joiner to join aggr and SQ(source).
o/p looks like after joinning
A 1
B 2
B 2
C 1
D 2
D 2
use router to route v_count=1 and v_count=2 to different targets.
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Why do you use Mapping Parameter and mapping variable?
Explain what transformation and how many are there in informatica?
What is sequence generator transformation in informatica?
Differentiate between a database and data warehouse?
What the difference is between a database, a data warehouse and a data mart?
How do you use reject loader.
What can we do to improve the performance of informatica aggregator transformation?
What is a joiner transformation?
How can you differentiate between powercenter and power map?
What is mapplet in informatica?
What is olap (on-line analytical processing?
How would you join a node to the already existing domain?
What's the layout of parameter file (what does a parameter file contain?)?
my source is junk data how will u remove that junk data by using unix please any one replay me
What is an expression transformation in informatica?