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
What is the difference between Active and Passive transformation?
Under which circumstances, informatica server creates reject files?
what is $$$$?
How many dimensions are there in informatica?
Scheduling properties,whats the default (sequential)
What is decode in static cache?
What is an active transformation?
Explain the pipeline partition with real time example?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
can you please explain me pre session and post session options?
How to configure mapping in informatica?
Can we override a native sql query within informatica?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
Explian the Process of deployment groups in informatica
Enterprise data warehouse your projects phase by phase explain?