1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

Question Posted / vijaya

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


Please Help Members By Posting Answers For Below Questions

Please let me know how to make Data masking in informatica..

1343

How do you promote a non-reusable transformation to reusable transformation?

767

What is the difference between STOP and ABORT options in Workflow Monitor?

802

expain about the tune parameters?

2006

what is the difference between informatica6.1 and infomatica7.1

1822




Explain pushdown optimization and types in informatica

747

What is aggregate cache in aggregator transformation?

712

How to load last n records of file into target table - informatica

703

Explain pmcmd command usage in informatica

797

What is a predefined event?

751

What is the way to execute pl/sql script using informatica mapping?

1083

How to call shell scripts from informatica?

662

what is INFORMATICA TESTING process

1943

Slowly changing dimensions, types and where will you use them

1363

How to create the source and target database connections in server manager?

710