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?

1 1145

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

1 1013

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

1 989

Explain me what is vldb?

1 996

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

1044

Explain the difference between keylokup and joiner?

1 952

Explain what are the various reporting tools in the market?

1 1038

Explain what is analytical or analytic mean?

1 1076

Explain how are the dimension tables designed?

1 1135

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

1 1018

What are the various transformation available?

1 1079

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

1 1163

What are the different types of join operations?

1 1073

Explain what is a three tier data warehouse?

1 1052

Explain piconet?

1 1026

Un-Answered Questions { Data Warehouse }

What sort of existing documents should business analysts refer to when starting on a new project?

1078

faq's on cognos

4112

Write the unconnected lookup syntax?

1151

Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com

2211

Explain scd type 3 through mapping.

1075

can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance

2306

what are the dimensions that you have in your current project?list them?

2095

1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

2794

what are the data modeling tools you have used?(polaris)

2060

hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..

1964

how to generate the test data in sas without input data? : Sas-administrator

1204

Demonstrate experience in maintaining quality process standards?

2674

How would you format some text using css to be verdana and bold?

1150

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

2084

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2824

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