Interested to Buy Any Domain ? << Click Here >> for more details...
Which one is better performance wise connected/un-connected
lkp?why?
- 2 Answers
- 14018 Views
- HCL, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / yamini
Performance wise unconnected look up transformation is better as it returns only one port and doesn't build any dynamic cache. Only static cache is build. It can be used any where in the mapping using LKP expression in another transformation.
| Is This Answer Correct ? | 4 Yes | 0 No |
What are the scheduling options to run a sesion?
In target table how to display the system time
What is the advantage of informatica?
Whats the difference between $, $$, $$$
How to join three sources using joiner? Explain though mapping flow.
How to extract sap data using informatica?
we have three columns and two rows. col1 col2 col3 a b c want to change into 2 columns and 3 rows ,how? col1 a col2 b col3 c which transformation u'll use and how?
What are the joiner caches?
Explain grouped cross tab?
what is incremental aggregation ,with example?
In update strategy target table or flat file which gives more performance ? why?
What are the reusable transforamtions?
Teradata 
