Informatica Interview Question and Answers

1. What is Data warehouse?
  According to Bill Inmon, known as father of Data warehousing. “A Data warehouse is a subject oriented, integrated ,time variant, non volatile collection of data in support of management’s decision making process”.
 
Your Name Your Email-ID
Your Answer
2. What are the types of data warehouses?
 
    There are three types of data warehouses
  • Enterprise Data Warehouse
  • ODS (operational data store)
  • Data Mart
 
Your Name Your Email-ID
Your Answer
3. What is Data mart?
  A data mart is a subset of data warehouse that is designed for a particular line of business, such as sales, marketing, or finance. In a dependent data mart, data can be derived from an enterprise wide data warehouse. In an independent data mart can be collected directly from sources.
 
Your Name Your Email-ID
Your Answer
4. What is star schema?
  A star schema is the simplest form of data warehouse schema that consists of one or more dimensional and fact tables.
 
Your Name Your Email-ID
Your Answer
5. What is snow flake schema?
  A Snowflake schema is nothing but one Fact table which is connected to a number of dimension tables, The snowflake and star schema are methods of storing data which are multidimensional in nature.
 
Your Name Your Email-ID
Your Answer