How to load query faster,so that It will take less time to load?
Answer Posted / karthik
You can increase the loading of query faster in following ways:
Query Optimization (Reducing the complexity in query).
Buffer cache increasing
Using Tier 0 (Flash storage) to increase IOPS.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is workflow? What are the components of workflow manager?
What is the surrogate key?
What are the different ways to implement parallel processing in informatica?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Why is sorter an active transformation?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
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
What is informatica? Why do we need it?
What are the prerequisite tasks to achieve the session partition?
What is the difference between router and filter?
what is INFORMATICA TESTING process
Explain joiner transformation in informatica
Explain sessions and how many types of sessions are there?
What is the need of etl tools?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?