Using Connected or unconnected lookup for performance wise which one is preferable?.
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 we use ENABLE HIGH PRECISION in session properties?
why we are using surogate key in real time give me explanation
What is a parameter When and where do you them when does the value will be created
What is the difference between SOURCE and TARGET BASED COMMITS?
what is the location of parameter file in informatica?
Is stop and abort are same in informatica?
from Source 100 rows are coming, on target there are 5 m rows which options is better to match data 1. Joiner 2 No cache 3. Static 4. Dynamic
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What are the uses of a Parameter file?
WHAT IS FACT TABLES?
can we use bulk loading when we use look in mapping
i have a table with name field. i,e name Shankar prabhakar nitikripa so no if a occures 3 times in name then it will go to tgt A if b occures 3 times in name then it will go to tgt b .. if z occures 3 times in name then it will go to tgt z