What is difference between a connected look up and
unconnected look up?
Answer / 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 |
Explain the difference between oltp and olap?
What is the difference between olap and datawarehosue?
Which are the olap tools available that are supported by oracle?
What is ETL process in Data warehousing?
Explain what are the different types of join operations?
What is freehand sql?
Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
What is data analytics in simple terms?
What needs to be done while starting the database?
What are the various methods of getting incremental records or delta records from the source systems?
How can you implement many relations in star schema model?
What is data type of the surrogate key?