Passive and Active transformation
State difference between Passive and Active transformation?
Expert
Active Transformation : An active transformation may change the number of rows that pass through it from source to the target that is it eliminates the rows that do not meet condition in transformation.
Passive Transformation : A passive transformation does not change number of rows which pass through it that is; it passes all the rows through the transformation.
What is the corresponding of Oracle/Db2 Coalesce Function within Sybase?
Write down the differentiation between lookup and filter transformation?
Explain why it is still essential to have at least certain familiarity with file processing systems even although it has become apparent that traditional file processing systems contain a number of shortcomings and restrictions.
Define the term OCI?
What is BCA? Discuss its features?
Explain, why we use the lookup transformations?
Specify the different Multidimensional analysis methods which are available in the Business Objects?
Does SDLC modify when you use the Teradata rather than Oracle?
Briefly describe the differentiation between Data warehousing and Business Intelligence?
Illustrate the term indexing. Specify the kinds of the indexing.
18,76,764
1941486 Asked
3,689
Active Tutors
1426316
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!