Top 30 Informatica Interview Questions and Answers ?

1.What is Data Warehousing?

2.What is Business Intelligence (BI)?

3.What is a Dimension Table?

4.What is a Fact Table?

5.What are the Fundamental Stages of Data Warehousing?

8.What are the Different Methods of Loading Dimension tables?

9.What is Data Mining?

10.What is the Difference between a View and a Materialized View?

11.What is a staging area?

12.What is OLAP?

13.What is the Difference between OLTP and OLAP?

13.What is ODS?

14.What is ER Diagram?

15.What are Lookup Tables?

16.What are Aggregate Tables?

17.What are Conformed Dimensions?

18.How do you Load the Time Dimension?

19.What is a Level of Granularity of a Fact Table?

20.What is a Factless Facts Table?

21.What are Slowly Changing Dimensions (SCD)?

22.What is a Surrogate Key?

23.What is Junk Dimension?

24.What is a Data Mart?

25.What is Schema? & Types of Schema?

26.Explain the Paradigm of Bill Inmon and Ralph Kimball.

Comments

A great career to Data Analyst fields

We are mid way in 2017 and we have been seeing some big changes in the business world. New forms of data analysis will be emerging to offer companies much more by way of Business Intelligence, operational guidance, and strategic market tactics. So what exactly will we see coming into play next year? I know that the education system in India still follows once in a 10 year syllabus appraisal system and students still think that computer industry means C, C++, Java and .Net (in some colleges, in fact they still teach COBOL. So ultimately they fall in love with these languages and feel disheartened if somebody asks them to work on something new. This is especially true for Data analytics & Business Intelligence as other IT work would have some amount of language programming (e.g. in Mobile/Web development etc.) but Data analytics & Business Intelligence is mostly playing with software tools at junior level . Data analytics & Business Intelligence has been bill

WHAT IS BUSINESS INTELLIGENCE (BI)?

BI is an abbreviation of the two words B usiness I ntelligence , bringing the right information at the right time to the right people in the right format. It is a 5-step process to run your business smarter, starting with registering the right data correctly, collecting the data from multiple sources, transforming, combining and storing it in a data warehouse. This data should be reported, analysed and distributed to the right people at the right time in the right format. The figure shows these steps.

Business Intelligence tools :

The most popular BI tools on the market are: 1] Oracle - Siebel Business Analytics Applications 2] SAS - Business Intelligence 3] SAP - BusinessObjects XI 4] IBM - Cognos 8 BI 5] Oracle - Hyperion System 9 BI+ 6] Microsoft - Analysis Services 7] MicroStrategy - Dynamic Enterprise Dashboards 8] Pentaho - Open BI Suite 9] Information Builders - WebFOCUS Business Intelligence. Etc

Business Intelligence & Data Warehousing

Search This Blog