Interested to Buy Any Domain ? << Click Here >> for more details...
1. if lookup tr is giving poor performamence. what u do.
2. i have emp,dept table. i want output
ename,empno,dname,max(sal).
3. can any one tell me project flow in real time scenario.
please send me mail any queries and answers
my mail id is yaparala@gmail.com
- 2 Answers
- 6801 Views
- HCL, iGate, I also Faced
- E-Mail Answers
Answer Posted / sandhya
Hi,
i dont know wether this is write or wrong .but in my way in look up we r having 2 modes cache &noncachemode noncache mode is low performance than the cachemode .bcz look up will maintains the connection with lookup table until comparision is completed.in cache mode lookup table data loaded into memory &dis connected from the lookup table this gives high performance
by using joins we can get the results as of my knowledge
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
What is tracing level?
what are the production issues in datastage?
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.
what are the reporting tools and difference between them?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
When do we analyze the tables? How do we do it?
What is a mapping, session, worklet, workflow, mapplet?
What are the three tiers in etl?
Explain do we need an etl tool? When do we go for the tools in the market?
What is the difference between round-robin partitioning and hash partitioning?
what is Forward,Reverse and Re_engineering?
1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?
how do u really know that paging to disk is happening while u are using a lookup transform?
What is a materialized view log?
how many steps are there in etl process?
