Slowly changing dimensions
Explain the slowly changing dimensions?
Expert
Dimensions which change overtime are known as Slowly Changing Dimensions(SCD).
Slowly Changing Dimension-Type1: That only has current records.
Slowly Changing Dimension-Type2: That has current records + historical records.
Slowly Changing Dimension-Type3: That has current records + one previous record.
Explain Triggers and Rules?
What do you understand by the term Dataset?
Illustrates the applications of ASA?
Describe the three types of data sources which are used with ODBC?
Under what conditions should indexes are employed?
Describe the term Derivations, Stage Variables and Constants?
What do you mean by optimization and performance tuning and explain how does it actually work in the practical projects?
Explain the standard folders?
How can I partition any table in Sybase? Explain.
What do you understand by the term JavaScript and VBScript in DBMS?
18,76,764
1934864 Asked
3,689
Active Tutors
1443074
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!