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 |
three ways sql*loader could load data, what are those three types?
Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?
Do you view contain data?
What is data stream and data adaopter?
What is query panel?
What is your spectra photometer working principles?
How many project sources we can create in metadata?
What is latest version of power center / power mart?
Briefly state different between data ware house & data mart?
What is ?Data Warehousing??
How many ways we test the universe & Report?
how to calculate sum(sal) with out using aggregator satge