Using Connected or unconnected lookup for performance wise which one is preferable?.
- 1 Answers
- 1910 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer / sam
Performance wise unconnected lookup transformation is better as it returns one port & does not build dynamic cache. only static cache is build .
| Is This Answer Correct ? | 0 Yes | 0 No |
Why do you use Mapping Parameter and mapping variable?
I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?
What is polling in informatica ?
When we enable pushdown optimization technique, two options will be enabled (use view,..). Can anyone tell me how these two options will work ? When do we need to go for pushdown optimization technique ?
How can you validate all mappings in the repository simultaneously?
How does a rank transform differ from aggregator transform functions max and min?
How can we remove the duplicates from flat file source?
How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????
What are the ETL tools available in DWH?
What are the different options available for update strategy?
How to generate or load values in to the target table based on a column value using informatica etl tool.
how to sort date field in infomatica?
Teradata 
