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 / srinu
I have a idea after sql transformation go thruogh 2 Agg
Trans,2 Router Trans
Agg1-gorup by col count=1 to router trans
Agg2-group by col count<>1 to router trans
I am not confident check itonce let me know,,
Thanks
Srinu
| Is This Answer Correct ? | 5 Yes | 17 No |
Post New Answer View All Answers
Explain the informatica workflow?
can we override a native sql query within informatica? How do we do it?
what is $$$$?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
Explain sessions. Explain how batches are used to combine executions?
what is Active lock explain
COM components can be used in Informatica
What is sorter transformation?
What is meant by lookup transformation? Explain the types of lookup transformation?
In development project what is the process to follow for an etl developer from day1
What is expression transformation?
What is native users?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
How do you use reject loader.
Why filter transformation is an active one?