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 lookup transformation in informatica
What is meant by target load plan?
What does role playing dimension mean?
Which is the t/r that builts only single cache memory?
Enlist few areas or real-time situations where informatica is required.
What is event and what are the tasks related to it?
What do you understand by term role-playing dimension?
What are the new features of informatica 9.x at the developer level?
Explain sessions. Explain how batches are used to combine executions?
What is different between the data warehouse and data mart?
Slowly changing dimensions, types and where will you use them
Whats the difference between informatica powercenter server, repositoryserver and repository?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
Explain the informatica workflow?
What you know about transaction control transformation?