how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Answer Posted / abhinaw prakash
If we are using a table as a source and we want to find out
the bottle neck is the SQ then run the mapping and note down
the timing which it has taken in reading the data from the
source and then replace the source with a Flat file.Note
down the timing and compare to find out the bottleneck in SQ.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Informatica settings are available in which file?
What is the function of union transformation?
What are the main issues while working with flat files as source and as targets ?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
complex mapping ur project u r invlve can u explain and give real time example give me ?
Please let me know how to make Data masking in informatica..
How to load a Dimension ? and how to load a fact table?
Can we override a native sql query within informatica?
Partition, what happens if the specified key range is shorter and longer
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
What is a repository? And how to add it in an informatica client?
What is a shortcut and copy in Informatica and how two are different with each other?
How can you increase the performance in joiner transformation?
hi real timers . iam waiting for ur reply regarding ETL TESTING
update strategy transformation in informatica