Interested to Buy Any Domain ? << Click Here >> for more details...
Which one is better performance wise connected/un-connected
lkp?why?
- 2 Answers
- 14151 Views
- HCL, TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Differentiate between sessions and batches?
What is Session and Batches?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What is the session task and command task?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Is there any way to read the ms excel datas directly into informatica?
Define enterprise data warehousing?
What is flashback table ? Advance thanks
What is a grid in Informatica?
What is meant by lookup transformation?
What is complex mapping?
draw informatica architecture 8.6 ?
What is a router transformation?
