Stage Variables and Constants
Describe the term Derivations, Stage Variables and Constants?
Expert
a) Derivation - Expression which specifies value that can be passed on to the target column.
b) Stage Variable – It is defined as an intermediate processing variable which retains the value during read and does not pass the value to the target column.
c) Constant - Conditions that are either true or false which specifies that flow of the data along with a link.
Explain and compare a procedure and a trigger?
Explain the Normalizer transformation?
Explain briefly the term data mart?
Illustrates the license for Clipper?
Write a brief note on the differences between a data warehouse and data mart?
How you can detect the loops?
Does the minimum spanning tree of a graph provide the shortest distance in between any of two gives nodes?
Give a brief introduction of the term active data warehousing?
State various types of the input links within the data stage?
Illustrates the term tkprof and how is this used?
18,76,764
1944835 Asked
3,689
Active Tutors
1430819
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!