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

suppose the network connection between a webserver and clustered i-server gets lost. What will happen? Will the report still run?

1027

Explain four-tier connection?

985

Explain star schema?

1029

How do you achieve schema object version control?

1044

What do you mean by consolidations?

1119

Explain the difference between holap and rolap?

1032

Explain fact table?

1107

Explain absolute filter?

1046

what are the different authentication modes available in microstrategy?

1181

What is a dw? Why do we need it?

1032

Explain adhoc reports?

981

How would you configure wh authentication?

1027

Imagine this, you are required to reset the password for all users at a time. How would you do that?

1010

What are prompted filters? Have you ever used them? Where?

1031

Can a record be inserted and updated in database using microstartegy?

993

Un-Answered Questions { Data Warehouse }

What are the various etl tools in the market?

1126

What is $mpjret?

1206

What are the ways to import data into catalog?

1140

can metadata be manually edited? If yes, how?

1073

Can you implement SCD2 using join, transformer and funnel stage?

1606

Give some difference between oltp and olap.

1070

r u done any partitions in ur project?

1871

How we drill up week to month?

1119

hi i need to rename a file in cognos8? can anyone help me out how 2 do it? pls suggest some solution such as using a batch file or using a procedure node or anything to rename the file

2425

Explain the importance of data warehouse?

1068

For which purpose Redshift is used for ?

if we have a delimiters at unwanted places in a flat file how can we over come those.

2094

How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...

1567

For faster process, what we will do with the universe?

1035

Explain normalization?

1208

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