Interested to Buy Any Domain ? << Click Here >> for more details...
Which one is better performance wise connected/un-connected
lkp?why?
- 2 Answers
- 13960 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
Slowly changing dimensions, types and where will you use them
What is a sequence generator transformation?
How do you migrate data from one environment to another?
What is powercenter on grid?
what is INFORMATICA TESTING process
How to update or delete the rows in a target, which do not have key fields?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
Can informatica load heterogeneous targets from heterogeneous sources?
How do you convert single row from source into three rows into target?
What is status code in informatica?
Explain how many types of dimensions are available in informatica?
Which is the t/r that builts only single cache memory?
Can we change Dynamic to Static or Persistent cache? If so what happens?
What is joiner transformation in informatica?
Explain sessions?
