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.
Describe truncate commands.
You have been given a setup of tables with data and inquired to make a new database to store them. What are you looking for, when you observe the data values in the tables?
Explain the standard folders?
Explain in brief the term data warehouse.
Write down the purpose of Fact-less Fact Table?
Who can create up a database or system team? Give a short demonstration of each.
Describe some of the chrematistics of good data definitions.
Illustrates the Pointer a variable in data structure or not?
States the term SnowFlake.
Explain terms Data Cache in Sybase. Answer: It is the memory area where data which is required for the current queries running is bought by Disk upon to memory for
18,76,764
1925359 Asked
3,689
Active Tutors
1435716
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!