Answer Posted / raji
which is maintaining more than one fact table is called
confirm dimension. which is reusable dimension.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are aggregate transformation?
What are Non-additive facts?
Explain how to export mappings to the production environment?
What is junk dimension? What is the difference between junk dimension and degenerated dimension?
Explain the different types of data warehousing?
what type of raid setup would you put your tx logs?
Fact table is in normalized or de-normalized form?
What is the purpose of cluster analysis in data warehousing?
Explain what does level of granularity of a fact table signify?
Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?
Compare aggregates and data marts
How did you plan your Data ware house project?
what are the others of "bad files" and "discard files" when using sql*loader?
Ist the schema that a data warehouse system can implements.
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?
