what is the main advantage of unconnected lookup
Answers were Sorted based on User's Feedback
Answer / praveen sh
If the same lookup table is used multiple times in the same
mapping, then it is better to go for un connected lookup.
Doing so we save cache memory and enhence performence
| Is This Answer Correct ? | 15 Yes | 0 No |
What are the components of Informatica? And what is the purpose of each?
Difference between session variables and workflow variables?
sorce is a flatfile only 1st and last row should insert to target how will u do?
1 lac of flat fles in source how to load target at a time?
Mention a few design and development best practices for informatica?
is it possible to index the data in cache of lkp transformation ?
how to connect two or more table with single source qualifier?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
State the differences between sql override and lookup override?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
I am using mapping variable, when i am running a session,before it has 10000 records, after completion of session what about value of mapping variable?
What is operational data source (ODS)?