⟩ What is galaxy schema?
Galaxy schema is also known as fact constellation scheme. It requires no of fact tables to share dimension tables. In data, wares housing mainly the people are using the conceptual hierarchy.
Galaxy schema is also known as fact constellation scheme. It requires no of fact tables to share dimension tables. In data, wares housing mainly the people are using the conceptual hierarchy.
Where the Data cube technology is used?
Can you pass sql queries in filter transformation?
After the generation of a report to whom we have to deploy or what we do after the completion of a report?
What is critical column?
What is data analysis? Where it will be used?
Explain the advantages of RAID 1, 1/0, and 5. what type of RAID setup would you put your TX logs.
Which technology should be used for interactive data querying across multiple dimensions for a decision making for a DW?
What is Informatica Architecture?
What is data warehouse architecture?
After the complete generation of a report who will test the report and who will analyze it?