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 many project sources we can create in metadata?

1106

What is the difference between static cache and dynamic cache?

1008

ware house management system is used?

1028

What function should we use to display the value entered or selected by a user in response to a prompt?

999

What are partition points?

1095

How can we transform row to column?

1 1481

How to stop a batch?

992

How to allow a dynamic selection of a column for a measure in a chart,without using variable?

1008

If two relational tables are connected to sq trans, what are the possible errors it will be thrown?

975

Suppose we want to display zero when null values coming to report how can we do that?

941

Suppose your client wants to ensure only specific users can create reports in query studio with other users creating reports using report studio. How can this be accomplished?

923

Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?

981

How to test report in reportnet?

1023

What are aggregate transformation?

1048

Tell me what is degree of a relation?

1009

Un-Answered Questions { Data Warehouse }

What is the difference between Standard and Metrics folder?

1096

What is meant by a Least Cost Plan?

1080

What is the difference between fastload and multiload? Which one is faster?

1244

How will effect the changes for a report , if for certain users only the column heading in the report should be changed?

806

What is scanmd and md doctor?

1078

describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?

2329

How can a graph be run infinitely?

1136

i was asked what are the caluclations done by you in your report? plz give reply

2206

How can one identify whether mapping is correct or not without connecting session?

1464

What is a full backup?

978

How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

2459

What is the function of aggregator transformation?

1097

Which function is used to count the number of intervals between two sas dates?

1141

what is the difference between nodup and nodupkey options? : Sas programming

1210

Explain the data type of the surrogate key?

962

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