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 do you add a number to a macro variable?

3 13367

If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable?

3 8846

Can you excute a macro within a macro? Describe.

3 8258

Can you use a macro within another macro? If so how would SAS know where the current acro ended and the new one began?

2 7015

Describe a time when you were really stuck on a problem and how you solved it?

1 3812

Describe the function and untility of the most difficult SAS macro that you have written.

2240

Give e an example of..

2350

Tell e how how dealt with..

Wipro,

2237

Are you involved in writing the inferential analysis plan? Tables specfications?

Wipro,

2577

What do you feel about hardcoding?

Pfizer,

3 16642

what is the necessity of oracle for business objects,why the interview panel is concentrating on oracle very much? Just we need the commands using select,joins? why they r asking about cursors,triggers etc..can any body answer me ..........Thanks in advance prakash

2 6111

What is the difference between sub-query & co-related sub query?answer ASAP....... thanks in advance..............Prakash

iFlex, Maintec, TCS,

3 20900

Can any body will explain about sarrogat key? Thanks in advance...........Prakash

7 10807

What is meant by Adhoc reports?Can any body will explain with examples...Thanks in Advance .........prakash

TCS,

7 21824

suppose case1:a person buy a car case2: rent a car which is context & which is alias? why?

IBM,

2 9103

Un-Answered Questions { Data Warehouse }

What is the difference between Datastage 7.5 and 7.0?

1113

Explain are data mart and dwh normalized or denormalized? Do both of them exist in

1049

tell me the rules and responsblites in our project(my project is development)

1944

What are the various tools used in etl?

1061

what specific features and functionality do you get with olap services?

978

What is the purpose of trailing @ and @@? How do you use them?

1049

What are different types of transformations available in informatica?

1014

What data formats does Redshift Spectrum support?

Compare sas with other data analytics tools.

1044

what is the use of surogate key in datastage

2333

How to restrict password to a user while sending a document in .pdf format

2356

Explain the difference between dw and bi?

1062

Explain what is power center repository?

1020

what is sas metadata repository? : Sas-bi

1130

How a routine is called in datastage job?

1137

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