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
What are cubes and olap cubes?
What do you understand by active and passive transformations?
How etl testing is different from database testing?
What is virtual Data Warehousing?
Identifying the bottlenecks in various components of Informatica and resolving them.
how many steps are there in etl process?
Define slowly changing dimensions (SCD)?
What is a materialized view log?
what is the main role of FI on business
what is the difference between cardinality and Nullability?
what is Forward,Reverse and Re_engineering?
When do we analyze the tables? How do we do it?
how to connect to a flatfile through ftp in informatica
how does the server recongnise the source and target databases.Elaborate on this
when will use SQL override in a lookup transformation?