how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Answer Posted / vijaya
BY seeing the session log file we identify the source qualifier bottle necks in the mapping
if we find the bottle neck on source qualifier transformation change the properties in SQ
Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
What is source qualifier transformation in informatica?
Explain dynamic target flat file name generation in informatica
Explain sessions. Explain how batches are used to combine executions?
Explain what transformation and how many are there in informatica?
What is a sequence generator transformation?
What are roles and groups and benefits of using them?
What are the measure objects?
How can we delete duplicate rows from flat files?
How can we use mapping variables in informatica?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Explain constraint based loading in informatica
What is a sorter transformation?
How big was your fact table
What is expression transformation?
explan ur project architecture?