What is difference between a connected look up and
unconnected look up?
Answer Posted / anil
Connected lookup
Unconnected
lookup
Receives input values diectly from the
pipeline
Receives input values from
the result of a
lkp expression in a
another transformation.
yoU can use a dynamic or static
cache U can use a static cache.
Cache includes all lookup columns used in the maping
Cache includes all lookup out put ports in the
lookup condition and the
lookup/return port.
Support user defined default
values Does not support
user defiend default values
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is difference between model & package?
Explain the difference between view and materialized view?
If two relational tables are connected to sq trans, what are the possible errors it will be thrown?
Explain which columns go to the fact table and which columns go the dimension table?
What are the difference between snow flake and star schema?
What are the various methods of getting incremental records or delta records from the source systems?
Explain me what is vldb?
Could any one explain me how to create cascading prompts?
What are aggregate transformation?
What is data mart in data warehouse?
ware house management system is used?
How to pivot data using informatica when you have variable amount of pivot rows?
Explain why fact table is in normal form?
What is bi?
What is junk dimension? What is the difference between junk dimension and degenerated dimension?