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
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
how do u extract data from different data sources explain with an example?
what are the cubes developed in a sap bw project and what is the requirement for developing it?
What is a lookup table in etl?
explain the methodology of Data Warehousing?(Polaries)
What is virtual Data Warehousing?
Define Dynamic push down optmization?
Difference between flat files and relational sources?
how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance
What is etl process. How many steps etl contains explain with example?
Explain about round-robi?
Give the benefits of data integration suite?
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com
Hi my name is kuldeep singh, i have finished my B.E in computer science and engg in 2008. I have worked with accenture for 17 months and because of family problem i left the job in dec 2009.. i was in data ware housing capability. right now i am working in a BPO as technicla support executive,, i want to move to IT again, please suggest me what shuld i do? its been 1 year gap and i am not able to get into IT...please suggest me ...should i go for informatica certification will that help me to get inot IT. please give ur suggestion..my E mail is is singh.kuldeep2004@yahoo.in
what are the reports developed in sap bw project and what is the requirement for developing it?