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
- 5805 Views
- HCL, iGate, I also Faced
- E-Mail Answers
Answer Posted / reddy guru
According to my knowledge write a query inlookup query
override or increase the cache size
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
what is different between sequential batch and concurrent batch and which is recommended and why?
What are the types of Data Warehouse applications?
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 three tier systems in etl?
how many steps are there in etl process?
What is a mapping?
how do u implement configuration management in Informatica?
how to load the data to fact table?
what is the main role of FI on business
Explain me ETL project architecture in Detail?
A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?
how would u estimate the size of Lookup transform data and index cache?
what are the production issues in datastage?
What is the difference between round-robin partitioning and hash partitioning?
What is abap? What are idocs?
