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

How to enable drills in a given column data?

856

What is a bridge table ?

888

What is scd type 1 and 2.

892

How we are going to decide which schema we are going to implement in the data warehouse?

832

What are the key configuration files in obiee?

964

What is authentication? How many types of authentication.

915

How will you port changes for dashboards,reports,rpd from development to production?

942

What are different types of joins that are possible in obiee rpd?

840

You come morning to the office. And all the users are complaining about the obiee reporting system is very slow(dasboards). What is your approach to resolve the issue?

871

What are the different types of security you have worked in obiee?

789

How to hide certain columns from a user?

852

What are the challenges you faced while making of reports?

848

What are global filter and how they differ from column filter?

967

What is a table alias in obiee? And where and how will you create it.

902

How will you execute direct sql in obiee?

917

Un-Answered Questions { Data Warehouse }

Explain do we need an etl tool? When do we go for the tools in the market?

1014

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1582

What are pass-through functions and why they are so called? Give some examples.

1027

What are the settings that you use to configure the joiner transformation?

1055

Tell me about % include and % eval? : sas-macro

1144

how do you create schema objects in 2 tier connection?

954

What happens to map if we alter the datatypes between source and its corresponding source qualifier?

1054

The question was on time stamp. what is the difference between HH and HH24 when to use when.

2057

How can you limit the variables written to output dataset in data step?

1318

What does microstrategy intelligence server allow users to do?

988

What are the steps to build the datawarehouse?

1040

How to update or delete the rows in a target, which do not have key fields?

1178

Can microstrategy intelligence server scale easily and cost effectively based on my growing needs?

1054

How to eliminate product joins in a teradata sql query?

1032

Define Data Stage?

1096

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