Using Connected or unconnected lookup for performance wise which one is preferable?.
Answer Posted / 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 |
Post New Answer View All Answers
Slowly changing dimensions, types and where will you use them
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
How can we update a record in the target table without using update strategy?
What is meant by lookup transformation? Explain the types of lookup transformation?
What is a stored procedure transformation?
How many numbers of sessions can one group in batches?
Different circumstance which drives informatica server to expel records?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What is an active transformation?
Define mapplet?
How to generate sequence numbers without using the sequence generator transformation?
What is the function of look up transformation?
What are the data movement modes in informatica?
generate date / time dimension in informatica
What is a transaction control transformation?