Interested to Buy Any Domain ? << Click Here >> for more details...
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
- 2 Answers
- 7017 Views
- Zensar, I also Faced
- E-Mail Answers
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
How can you generate reports in informatica?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Explain informatica architecture - version 8 / 9
What is Data Caches size?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What is informatica?
What is the difference between a repository server and a powerhouse?
Is it possible to create multiple domains on a single Informatica server?
What are the types of schemas we have in data warehouse and what are the difference between them?
How to call shell scripts from informatica?
Describe the impact of several join conditions and join order in a joiner transformation?
How can one identify whether mapping is correct or not without connecting session?
design of staging area?
What are active and passive transformations?
can u give example for factless fact table
