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
- 6913 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
expain about the tune parameters?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
Explain incremental aggregation in informatica
Can u generate reports in Informatica?
What do you mean incremental aggregation?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
explan ur project architecture?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What is union transformation?
What is dimensional table?
What is deployment group?
How to handle decimal places while importing a flatfile into informatica?
Can we create two repositories on same database instance in oracle?
How do you manage the Parameter files while migrating your data from one environment to another environment?
