Data Warehouse Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Teradata (490)
Business Objects (875)
Cognos (1143)
Informatica (2428)

SAS (1049)
Micro Strategy (282)
ETL (315)
OBIEE (92)

Data Warehouse Interview Questions

Questions Answers Views Company eMail

What is the differences between star and snowflake schemas?

1080

What are the various methods of getting incremental records or delta records from the source systems?

943

Explain which columns go to the fact table and which columns go the dimension table?

937

Explain me what is vldb?

938

Explain have you ever been in a real dilemma at work? What did you do to get out of it?

970

Explain the difference between keylokup and joiner?

902

Explain what are the various reporting tools in the market?

995

Explain what is analytical or analytic mean?

1027

Explain how are the dimension tables designed?

1070

Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?

969

What are the various transformation available?

1027

Explain a mapping, session, worklet, workflow, mapplet?

1120

What are the different types of join operations?

1013

Explain what is a three tier data warehouse?

982

Explain piconet?

970

Un-Answered Questions { Data Warehouse }

hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?

2078

lookup transformation with screenshots

4014

What is a predefined event?

1103

What is dimensional table? Explain the different dimensions.

1181

How to performance tune reports?

1188

What is m_dump?

1241

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1986

Scheduling properties,whats the default (sequential)

1969

what are the categories that sas informats are used to the place the data? : Sas-administrator

1066

Explain do we need an etl tool?

1031

The methods to improve performance of a graph?

1090

explain abt ur project architecture?

2204

Repository user profiles

1774

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

2071

Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

2868

For More Un-Answered { Data Warehouse } Questions Click Here