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?

902

What is a bridge table ?

958

What is scd type 1 and 2.

934

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

883

What are the key configuration files in obiee?

1014

What is authentication? How many types of authentication.

971

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

991

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

893

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?

917

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

834

How to hide certain columns from a user?

895

What are the challenges you faced while making of reports?

898

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

1036

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

949

How will you execute direct sql in obiee?

966

Un-Answered Questions { Data Warehouse }

how can you create zero observation dataset? : Sas programming

1205

What is the difference between partitioning with key / hash and round robin?

1486

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

1053

Highlight the points of differences between the database and user in Teradata.

1170

How to convert multiple rows to single row (multiple columns) in informatica

1429

How create measures and demensions?

1093

Describe the ways in which you can create macro variables?

1261

What is a staging area? Do we need it? What is the purpose of a staging area?

1050

What are the limitations of amazon redshift?

What is data stream and data adapter is it same are different? Explain?

1033

Explain the shared cache and re-cache?

1169

What is the maplet?

1209

What is dimensional table? Explain the different dimensions.

1258

What steps should be taken to improve Datastage jobs?

1124

Please let me know how to make encryption and decryption with example?

1952

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