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
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
How to do the error handling of if ur source is flatfiles?
Write the different tools in the workflow manager?
According to his methodology what all you need before you build a datawarehouse
What are some examples of informatica etl programs?
Tell me about Propagate functions in informatica
Explain the use of aggregator cache file?
How to handle decimal places while importing a flatfile into informatica?
write a query to retrieve the latest records from the table sorted by version(scd)
what is the hint? how to use it to reduce the query processing in program?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
Explain joiner transformation in informatica
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
How to configure mapping in informatica?
What is informatica metadata and where is it stored?