Interested to Buy Any Domain ? << Click Here >> for more details...
Which one is better performance wise connected/un-connected
lkp?why?
- 2 Answers
- 13801 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
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
Define mapplet?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What is meant by a domain?
what are the deliverables?in your project?
What is informatica?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What is data movement mode in Informatica and difference between them?
What is meant by lookup transformation?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
How to create Target definition for flat files?
What does update strategy mean, and what are the different option of it?
How can we use mapping variables in informatica?
