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 would you generate 1000 observations from a normal distribution with a mean of 50 and standard deviation of 20. How would you use PROC CHART to look at the distribution? Describe the shape of the distribution.

1 15231

How do you generate random samples?

5 10791

What is the purpose of using the N=PS option?

Oracle,

2 18656

Describe how you would pass data to macro.

3 12962

How would you code a macro statement to produce information on the SAS log? This statement can be coded anywhere.

8 12730

How do you add a number to a macro variable?

2 8003

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?

2 5323

Can you excute a macro within a macro? Describe.

Genta,

2 6436

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

1 5630

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

DELL,

2564

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

2133

Give e an example of..

2107

Tell e how how dealt with..

2265

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

2237

What do you feel about hardcoding?

1 5270

Un-Answered Questions { Data Warehouse }

what is the difference between informatica6.1 and infomatica7.1

2293

How is the teradata different from oracle?

1126

What is job control?

1130

What are non-additive facts in detail?

1008

can you please explain me pre session and post session options?

7594

Separate from an archive server and a powerhouse?

972

What do you mean by tpt in teradata?

1030

What is intricate mapping?

1222

Code check-in and check-out commands in AbInitio

4327

how you can enable bulk load mode in ti?

What is degenerate dimension table?

1014

Explain the different kinds of facts.

998

Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?

2257

What is apt_config in datastage?

1154

What is data warehouse architecture?

1057

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