What is Drill up/down/by/through
Explain what is meant by the Drill up/down/by/through?
Expert
a) Drill mode enables you to analyze the data from several angles and on the different levels of detail.
b) Drill down exhibits the next level of detail in the hierarchy.
c) Drill up goes back up through the hierarchy in order to display the data over the less detailed levels.
d) By using the Drill through the option you may move to the other hierarchy in order to analyze other data which belongs to the different hierarchy.
e) Drill Through - If lowest level of detail you require is not currently available within the report, you may drill through to the database directly from the drill mode and obtain the data you require. You do not need to edit the query within the Query Panel.
Define the Fully Functional dependency.
Explain the types of jobs we have within the Data stage?
Give a brief introduction of the term Dimensional Modeling?
Explain the Hash file and the Sequential File?
Describe how a scenario is employed for business rule?
Describe briefly the term data warehouse?
Illustrates the mobile enterprise application enablement?
States the term Volatile temporary tables.
Name the main data structures used in these areas: Hierarchical data model, RDBMS and Network data model?
Briefly describe the ETL procedure in data warehousing?
18,76,764
1949211 Asked
3,689
Active Tutors
1415577
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!