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 the linked universes?
Explain the types of jobs we have within the Data stage?
Explain the user objects?
Write down the differentiation between lookup and filter transformation?
Write down the brief notes on multidimensional data model.
Give a brief differentiation between metadata and data dictionary?
Whenever we are prepared to create a table in DBMS than what are the steps to follow?
Which technique is used in the BCA?
What do you understand by the term SQL view in DBMS? Briefly describe the utilization of views?
Elucidate how many kinds of dimensions are accessible in the Informatica?
18,76,764
1949536 Asked
3,689
Active Tutors
1445228
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!