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


Please Help Members By Posting Answers For Below Questions

How do you setup Lo-cockpit?

2638


What are the different types of fact tables used in data warehousing?

563


What are data modeling and data mining?

670


What is cost benefit analysis (cba)?

593


What are the data types present in bo? What happens if we implement view in the designer n report?

553






What is data analysis?

546


Can any one explain about core dimension, balanced dimension, and dirty dimension?

648


How to create diff. Types of templates?

568


What we will do with the universe for faster process?

581


What are the approaches used by optimizer during execution plan?

499


Explain the data types present in bo n wht happens if we implement view in the designer n report?

546


Explain the difference between view and materialized view?

520


What are situations where snowflake schema is better than star schema when the opposite is true?

571


What is Cognos script editor?

2080


How can we do data cleaning?

594