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 are the different types of join operations?
Explain what does level of granularity of a fact table signify?
What is data warehosuing hierarchy?
Explain the process of extracting data from source systems,storing in ods and how data modeling is done?
What are the mapping paramaters and maping variables?
What are modeling tools available in the market?
What is the goal of optimizer?
What is the main difference between inmon and kimball philosophies of data warehousing?
Explain what is full load & incremental or refresh load?
What is the use of incremental aggregation? Explain me in brief with an example?
Tell me what is full load & incremental or refresh load?
What is the difference between ods and oltp?
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
What is crass reference table?
What is execution plan?