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 can create users and permissions in cognos?

962

What is the difference between group and associare?

1050

What is the difference between a cascading report and drillthru report? Why do we go for drill thru report?

952

What are the other methods working as deployment functionality?

951

What junk dimension contains?

1000

What are products of cognos?

978

What is the difference b/w macros and prompt?

1140

How can we create a dynamic column name in cognos?

961

Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?

970

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

1029

What is the difference between drill through, drill across?

1090

Give me any example of semi and non additive measures?

977

What is zero-foot print?

1024

Please explain the different stages in creating a report in cognos report net?

1010

What is difference between page break and section report? What is main advantage datawarehousing over oracle?

1020

Un-Answered Questions { Data Warehouse }

explain the use of % includes a statement in sas? : Sas-administrator

1008

How you can read the variables that you need?

1126

what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2325

Can schema objects be copied across projects with microstrategy object manager?

987

how can we create rank using datastage?what is the meaning of rank?

8796

What is Online View?

1967

Explain true primary keys?

1008

Describe 5 ways to do a “table lookup” in SAS?

1155

What is the meaning of decode in informatica?

1123

What happens in a conflict? How do you handle that?

1051

Lookup constraints

1264

Explain input and put function?

1147

Mention what is SAS data set?

1137

how can we analyze the locks ?

2136

What is difference between query studio and report studio?

1095

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