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

Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?

1019

What are the data types present in bo? What happens if we implement view in the designer n report?

1002

What are the data types present in bo?

1217

What is meant by metadata in context of a data warehouse and how it is important?

1280

How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.

1107

what is difference between drill & scope of analysis?

1181

Which technology should be used for interactive data querying across multiple dimensions for a decision making for a dw?

1143

What is the difference between olap and oltp?

1148

Can you pass sql queries in filter transformation?

1083

What is meant by metadata in context of a data warehouse?

1031

What is a data profile?

1037

Can a dimension table contain numeric values?

1122

What do you mean by static and local variable?

1023

Can any one explain the hierarchies level data warehousing.

1047

Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.

958

Un-Answered Questions { Data Warehouse }

Hi, I have Cognos 7.0 Impromptu reports and these reports have been created with the Mainframe datasource. Now the business needs these reports should be upgraded but with Oracle datasource. So what's the idea, first we should migrate these reports into ReportNet? then in that case what we will do with the Impromptu Catalog? Second, suppose we need to migrate these reports into Cognos 8 (may be 8.4) then how we will do that? do we need to create a FM Model for these reports. Please advice!

2068

What are the different type of jobs in datastage?

1092

Explain me what are conformed dimensions?

1110

what can you learn from the sas log when debugging? : Sas programming

1147

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

1032

You are required to update a table in warehouse. Can you do it with the help of microstrategy?if yes, how?

984

how to run a sequential file stage in parallel if the stage is used on the TARGET side

1803

how does sas handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, procs? : Sas programming

1085

What do you mean by parsing?

1171

What are level metrics? Why are they needed?

1097

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...

1569

How to create or import flat file definition in to the warehouse designer?

1145

How you will check the version of teradata?

1235

Explain in detail about scd type 1 through mapping.

1639

What is real-time datawarehousing?

1082

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