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 are roles and groups and benefits of using them?
What is the meaning of decode in informatica?
What are the transformations that are not supported in mapplet?
What is the Rank index port in Rank transformation?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
Global and Local shortcuts. Advantages.
What is target load order?
lookup transformation with screenshots
How to Create a folder using pmrep command?
Is there any target staging area in informatica not staging area
Define sessions in informatica etl?
What is an unconnected transformation?
How to create the source and target database connections in server manager?
Briefly define a session task?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?