How to eliminate duplicates in FF and oracle both
Answer Posted / ravindra.15aug
In RDBMS we can write sql queary in Source qualifer by
using rowid, in sorter by using select distinct option, In
aggregator by using groupby, in Rank by using groupby.
In FF level also we can do except sql queary in source
qualifier.
Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
What is dimensional table?
What are session parameters ? How do you set them?
Explain constraint based loading in informatica
What are the differences between joiner transformation and source qualifier transformation?
What is an expression transformation in informatica?
What are mapplets? How is it different from a Reusable Transformation?
Explain the features of connected and unconnected lookup.
What are pre and post-session shell commands?
How to update source definition?
What is Cognos script editor?
Explain the code page compatibility?
Write the unconnected lookup syntax and how to return more than one column.
Mention a few design and development best practices for informatica?
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