Interested to Buy Any Domain ? << Click Here >> for more details...
How to load query faster,so that It will take less time to load?
- 1 Answers
- 3836 Views
- BNP Paribas, I also Faced
- E-Mail Answers
Answer / 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 |
What are the issues u have faced in ur project? Guys pls answer to dis question.Due to this question I have failed in 3 interviews.
i have source file data empno,ename,sal 100,ram,1000 200,tyu,2000 300,gh,3000 out put as e empno,ename,sal 100,ram,null 200,tyu,1000 300,gh,2000 how to load it?
What does role playing dimension mean?
What is 'PowerCenter Pushdown Optimization Option' in INFORMATICA ?
I am Unable to load the FixedWith FlatFile Into The Target.What Is The Reason. PLZ Help Me..
What is workflow monitor?
Is LOAD MANAGER AND LOAD BALANCER same in informatica?
How to handle changing source file counts in a mapping?
If there are more than one sessions running parallel in a worklet, which will be the last session ?
how much memory (size) occupied by a session at runtime
what is the flat file partition and where have to specify it
hi all when i am creating repository contents i am getting this error and not able to create contents please let me know wht may be the problem ORA-01031: insufficient privileges Database driver error... Function Name : executeDirect SQL Stmt : CREATE VIEW REP_DATABASE_DEFS AS SELECT DISTINCT DBDNAM DATABASE_NAME, SRCNAM DEF_SOURCE, SUBJ_NAME SUBJECT_AREA, NULL VERSION_ID, OPB_DBD.VERSION_NUMBER DATABASE_VERSION_NUMBER FROM OPB_DBD, OPB_SUBJECT, OPB_SRC WHERE OPB_DBD.SUBJ_ID = OPB_SUBJECT.SUBJ_ID AND OPB_SRC.DBDID = OPB_DBD.DBDID AND OPB_SRC.VERSION_NUMBER = OPB_DBD.VERSION_NUMBER AND OPB_SRC.IS_VISIBLE = 1 Oracle Fatal Error Database driver error... Function Name : ExecuteDirect Oracle Fatal Error Error occurred while creating the repository An error has occurred while creating contents. Dropping repository tables... Create Contents operation on repository [reposerv] ended at 01/02/2009 13:02:48. Elapsed time is 0:00:09.
Teradata 
