Warehousing and ____ are substitutes for each other.
Answer
Correct Answer:
Transportation
Note: This Question is unanswered, help us to find answer for this one
During ETL load we generally have
Answer
Correct Answer:
Sorted data for Aggregator
Note: This Question is unanswered, help us to find answer for this one
You need to create an index on the SALES table, which is 10 GB in size. You want your index to be spread across many tablespaces, decreasing contention for index lookup, and increasing scalability and manageability.
Answer
Correct Answer:
Partitioned
Note: This Question is unanswered, help us to find answer for this one
Which type of table is usually created to enable the building of scalable applications, and is useful for large tables that can be queried or manipulated using several processes concurrently?
Answer
Correct Answer:
Partitioned table
Note: This Question is unanswered, help us to find answer for this one
In Star Schema Dimension tables are:
Answer
Correct Answer:
Short and Fat
Note: This Question is unanswered, help us to find answer for this one
Centipede fact table means:
Answer
Correct Answer:
Fact table with to many dimensions
Note: This Question is unanswered, help us to find answer for this one
Dimensions are Confirmed when:
Answer
Correct Answer:
They are either same or one is subset of another
Note: This Question is unanswered, help us to find answer for this one
In 4 step dimensional process, declaring grain of business process is:
Answer
Correct Answer:
Second Step
Note: This Question is unanswered, help us to find answer for this one
In datamarts stovepipe means:
Answer
Correct Answer:
Isolated data
Note: This Question is unanswered, help us to find answer for this one
In which type of SCD(Slowly changing dimensions) do we preserve history of data:
Answer
Correct Answer:
Type Two
Note: This Question is unanswered, help us to find answer for this one
In general data in Data Warehousing is:
Answer
Correct Answer:
None of Above
Note: This Question is unanswered, help us to find answer for this one