Interested to Buy Any Domain ? << Click Here >> for more details...
why we use source qualifier transformation?
- 16 Answers
- 45878 Views
- Accenture, I also Faced
- E-Mail Answers
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 to load data in informatica ?
What are the different types of olap? Give an example?
What is meant by LDAP users?
What are roles and groups and benefits of using them?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What is dimensional table?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What is flashback table ? Advance thanks
What is a repository? And how to add it in an informatica client?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What is a predefined event?
What is Cognos script editor?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
