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

what is report view?

Cap Gemini,

4 10492

what is the difference b/w mdx and sql?

Cap Gemini, IBM,

4 21393

what is render variable

Accenture, Cap Gemini, Systime, TCS,

5 42491

what is cognos architechure

Cap Gemini,

4 15973

I have 50 variables in one data set, In reports i want to generate every 10 variables in one page how we will write code in proc report.

4 8801

advantages of cascade prompt ???

iFlex, Oracle,

7 14913

advantages of detailed filter??? and summarized filter???

iFlex,

4 12843

how u provide security in power play transformer???

iFlex, ITC Infotech, TCS,

3 21511

set scope level in transformer

2 11733

how to work with mapplet designer in informatica?

7 24648

What are the main differences between sas versions 8.2, 9.0, 9.1?

4 12560

How to read multiple excel sheets from a single excel file at once????

HCL, Verinon Technology Solutions,

7 18659

i have two flat files.. containing same type of data i want to load it to dwh..how many source qualifires i need

Deloitte,

7 25944

@prompt('message',['type'],[lov],[mono/multi], [free/constraint]) what is Constraint?

iGate,

4 13785

How to generate the HTML output using Informatica.

Wipro,

3 12152

Un-Answered Questions { Data Warehouse }

What are the difference between snow flake and star schema?

1019

Where the cache files stored?

1026

List out some of the air commands used in abintio?

1400

what is the size of your data warehousing?

2114

Why redshift Distribution key is used?

Explain append procedure?

1102

What are the types of studio present in Cognos?

1049

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

1163

describe about physical data integration? : Sas-di

1060

What are the processing stages?

1111

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

1039

what is the meant by Normalization and de-normalization?

2730

Can sorting and storing be done through single software or you need different for these approaches?

1132

What is a Pivot?

1172

What is the difference between Open Connection command ang Open Session Command?

2461

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