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 the difference between STOP and ABORT options in Workflow Monitor?
draw informatica architecture 8.6 ?
What are mapplets?
What is the meaning of decode in informatica?
What are the types of caches in lookup?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
What's the layout of parameter file (what does a parameter file contain?)?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
Explain target update override in informatica
How many input parameters can exist in an unconnected lookup?
What is a grid in Informatica?
What is a shortcut and copy in Informatica and how two are different with each other?
What is rank index in rank transformation?