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
Explain your project of banking domian.
Explain the types of lookup transformation?
What are the different versions of informatica?
How to load the data from people soft hrm to people soft erm using informatica?
How are the sources and targets definitions imported in informatica designer?
What are the uses of etl tools?
what is unit testing?tell me proceedure
Is there any target staging area in informatica not staging area
What does update strategy mean, and what are the different option of it?
How to generate sequence numbers using expression transformation?
What are roles and groups and benefits of using them?
Mention few power centre client applications with their basic purpose?
what is Active lock explain
What is a filter transformation?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa