Data warehouse is made up of many datamarts. DWH contain many subject areas. However, data mart focuses on one subject area generally. E.g. If there will be DHW of bank then there can be one data mart for accounts, one for Loans etc. This is high-level definitions.
How can you implement many relations in star schema model?
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?
rendc.org
Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."
Get all the latest information on rendc.org
© 2022 | All rights reserved.
RENDC
welcome to www.rendc.org
