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
What are the designer tools for creating transformations?
How to do unit testing in informatica?
Design time, run time. If you don't create parameter what will happen
What are the types of schemas we have in data warehouse.
How might you approve all mappings in the archive all the while?
What are the different options available for update strategy?
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
Enterprise data warehouse your projects phase by phase explain?
What are the new features of informatica 9.x in developer level?
What is the sequence generator transformation in informatica?
What is Session and Batches?
What are the different versions of informatica?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?