Interested to Buy Any Domain ? << Click Here >> for more details...
Which one is better performance wise connected/un-connected
lkp?why?
- 2 Answers
- 13863 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
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
How can you validate all mappings in the repository simultaneously?
How does a sorter cache works?
What are the tasks that can be performed using sq?
What is the use of code page?
What is an Integration service in Informatica?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
How can we use mapping variables in informatica?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
How many numbers of sessions can one group in batches?
Clarify the aggregator change?
What will be the approach?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
what is the -ve test case in your project.
What is a repository? And how to add it in an informatica client?
