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

What are the different types of join operations?

560


Explain what does level of granularity of a fact table signify?

531


What is data warehosuing hierarchy?

581


Explain the process of extracting data from source systems,storing in ods and how data modeling is done?

521


What are the mapping paramaters and maping variables?

568






What are modeling tools available in the market?

558


What is the goal of optimizer?

588


What is the main difference between inmon and kimball philosophies of data warehousing?

659


Explain what is full load & incremental or refresh load?

535


What is the use of incremental aggregation? Explain me in brief with an example?

583


Tell me what is full load & incremental or refresh load?

512


What is the difference between ods and oltp?

572


what is the synchonus? wht is the diff between synchronous and asynchronous what is the diff between v1 and v2 v3 delta modes in sap ecc

2051


What is crass reference table?

595


What is execution plan?

749