how can one eliminate dupliacte data with out using
distinct option?
Answer Posted / sunil
By using aggrator select groupby port to eliminate
duplicates
| Is This Answer Correct ? | 31 Yes | 0 No |
Post New Answer View All Answers
What is domain in terms of informatica?
What is the meaning of decode in informatica?
How we can create indexes after completing the load process?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
Can you use flat files in Mapplets.
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
Explain incremental aggregation in informatica
How to create a non-reusable instance of reusable transformations?
What is a pre-defined event and user-defined event?
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
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
How do you load only null records into target? Explain through mapping flow.
what are the Methods For Creating Reusable Transformations?
How can we improve session performance in aggregator transformation?
What is workflow manager?