why we use source qualifier transformation?
Answer Posted / pooja amhed
hi,
we use SQ trans as 1st trans due to its properties. in SQ
trans i means at the begin of extracting of data its self
we can remove duplicate ,we can filter,join,override the
query,pre and post sql querey.... in orther words we use it
to impore the performance.
| Is This Answer Correct ? | 16 Yes | 4 No |
Post New Answer View All Answers
What is lookup change?
What is domain and gateway node?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
what is unit testing?tell me proceedure
Define enterprise data warehousing?
Explain the difference between mapping parameter and mapping variable?
Why filter transformation is an active one?
What are the types of caches in lookup?
How can a transformation be made reusable?
Explain pmcmd command usage in informatica
What are the different options available for update strategy?
What is a stored procedure transformation?
What are multi-group transformations?
How we can use union transformation?
Explain about Informatica server process that how it works relates to mapping variables?