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 15312

How do you generate random samples?

5 10935

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

Oracle,

2 18735

Describe how you would pass data to macro.

3 13080

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

8 12990

How do you add a number to a macro variable?

2 8121

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 5411

Can you excute a macro within a macro? Describe.

Genta,

2 6535

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 5690

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

DELL,

1 2616

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

1 2175

Give e an example of..

1 2146

Tell e how how dealt with..

1 2318

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

1 2271

What do you feel about hardcoding?

1 5346

Un-Answered Questions { Data Warehouse }

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

838

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1654

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

4011

What is the difference between business requirement document and use case document.

1073

What is a rollup component? Explain about it.

1232

Demonstrate experience in maintaining quality process standards?

2658

i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..

2759

hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..

1951

hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.

2054

Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin

2161

Hi friends, what are the new features in abinito3.0?

2854

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4788

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8274

hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com

2425

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1231

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