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 10491

what is the difference b/w mdx and sql?

Cap Gemini, IBM,

4 21385

what is render variable

Accenture, Cap Gemini, Systime, TCS,

5 42479

what is cognos architechure

Cap Gemini,

4 15971

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 8798

advantages of cascade prompt ???

iFlex, Oracle,

7 14898

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

iFlex,

4 12837

how u provide security in power play transformer???

iFlex, ITC Infotech, TCS,

3 21504

set scope level in transformer

2 11731

how to work with mapplet designer in informatica?

7 24640

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

4 12557

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

HCL, Verinon Technology Solutions,

7 18645

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 25940

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

iGate,

4 13776

How to generate the HTML output using Informatica.

Wipro,

3 12150

Un-Answered Questions { Data Warehouse }

What are the different functions included in the server software?

1049

How do you create surrogate key using ab initio?

1006

hi this is bhaskar iam working in Tcs u want any real time faqs send me your qs i will ans that qs ok this is my id bhaskarparitala.rao@gmail.com

2142

What are the main differences you have observed between 7.x and 8.x version of datastage?

1101

Name any two stages of the data processing cycle and provide your answer in terms of a comparative study of them?

1135

What is the difference between the proc sql and data step?

1192

How will you generate test data with no input data?

1185

What are various types of gateways in cognos?

1080

What is pass through metrics in microstrategy?

999

How to delete duplicate row using informatica?

1058

What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?

5660

What is execution plan?

1210

What are types of batch available in cognos?

985

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5807

Mention what is a partition and what are the different types of partition components in abinitio?

1201

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