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
- 7089 Views
- Zensar, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
When will you use SQL override in a lookup transformation?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000
What is workflow monitor?
why we use materialized view over view?
Briefly define a session task?
HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND LOOKUP?
wt is the difference between truncate and delete in which situation u use delete and truncate in real time..
In informatica workflow manager, how many repositories can be created?
Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation
What is primary and backup node?
scd methodology?
Teradata 
