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
Answer Posted / hitesh
but in this we ll get distinct values in duplicate table.
how can i get all values in duplicate table like:
col1 col2
1 2
1 2
1 2
3 4
3 4
5 6
and i want
unique table:
5 6
and
duplicate table :
1 2
1 2
1 2
3 4
3 4
i know this is of no use, but can we do this??
pls rply
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is a grid in Informatica?
How to update or delete the rows in a target, which do not have key fields?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
How would you join a node to the already existing domain?
what is the difference between informatica6.1 and infomatica7.1
What are the designer tools for creating transformations?
What are mapplets?
What is a predefined event?
what are the deliverables?in your project?
what is $$$$?
How do you set a varible in incremental aggregation
What is workflow monitor?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What is sorter transformation?
difference between informatica 8.1.1 and 8.6