why we use source qualifier transformation?
Answer Posted / vankayalapati sankar
souce qualifies transformation we can use to reduce the perfomence tunning pupose and minimum four transformations cover in it.what are those 0ne resone two join the two table in this case we can use the joiner transfomation,secound resone filter condition applied in source filter option in source qualifier transformation in that case filter tranformation cover it.third resone distinct option we can use to dublicate records remove in that case sorter tranformation cover.fourth resone sql qerry write in sql qerry option use it.in that case lookup transformation cover
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How can you differentiate between powercenter and power map?
What are data-driven sessions?
What you know about transaction control transformation?
What are the components of Informatica? And what is the purpose of each?
explain one complex mapping with logic? sales project?
Explain the mapping variable usage example in informatica
how we can load rejected record's at run time?(not through bad files)
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Tell me about Propagate functions in informatica
How do we call shell scripts from informatica?
Which transformation should we use to normalise the COBOL and relational sources?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
How can you generate reports in informatica?
What are the tasks that can be performed using sq?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?