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

Your application mode has crashed. How would you get the instance back?

938

What do you mean by mstr?

1098

What do you mean by bulk export report?

942

What do you mean by xml cache?

974

Is it possible to get a floating window in microstartegy web? If yes, how?

1161

Explain fact structure?

988

What are the different types of mstr objects?

1003

How will you monitor the errors received while running i-server and report?

948

Can you explain surrogate key?

1042

Your application mode has crashed. How would you run your i-server?

982

What is an i-server? What are the different modes to run it?

978

How would you increase the logical size of a table in microstrategy?

973

According to you, what are the most important tables in a dw? Why?

985

Explain scan md?

1079

Explain fact constellation schema?

1037

Un-Answered Questions { Data Warehouse }

What are datastage sequences?

1119

Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?

3625

What you mean by drill across and what is the difference between drill through, drill across?

1028

Which development components of informatica have the highest usage?

1044

What are the different options available for update strategy?

1004

----------------Describe DWH Architecture?

2066

What is the return type of lookup_not_loaded() ? Does it return 0 or 1 to signify true or false or does it return index ...can someone please explain.

1373

How co> operating system natively processes the data?

1099

how can you put a "trace" in your program? : Sas programming

1065

What are the repository tables in datastage?

1309

What is rank index in rank transformation?

1080

What are the differences between source qualifier and joiner transformation?

1062

Can you define report item?

1036

What are the functions involved in shared information architecture?

1073

How substr function works in sas?

1222

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