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 the difference between proportion and average?

KPMG,

3336

what is amp plz explanation

IBM,

5 8554

what is use of PI(primary index) AND SI(secondary index)

Wipro,

2 7386

Why we use ENABLE HIGH PRECISION in session properties?

Cognizant,

2 14319

why dataset ?

2 5996

Data transformed successfully from Source table to target table. Now how you will ensure that the data in Target table is proper. I answered will verify one or two records and check Then question was that the Development is doing (1-2 record verification)but as a tester you have to verify the complete data, how you will do?? Please answer

2 5451

Hi Friends,what are The Advantages In Cognos 10 Compared To Cognos 8.4?Enhancements in Cognos 10? Please Ans Me Pls

1 6115

you have a data set like this. data qqq; input name $ total; cards; qq 22 ww 33 qq 22 ee 44 rr 33 ww 44 ; run; and you want output like this......... name total qq 22 ww 44 Do it by data set step.

6 10224

how to read raw data in sas. Do it manually and throw the programming.

WNS,

1 7706

How do we do the Fact Load What is the size of your Data warehouse? What is your Daily feed size and weekly feed size

1 8080

write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.

5 7775

Hai frnds, Any body tell to What is Granularuty in cognos Please help me.i can search in so many browsers but i canot get the answer

Wipro,

3 7062

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

3166

Hi, i want to do certification in datawarehouse?? which certification is best in current trend?? pls mention the cost also if u can....

2341

In a column if the value is >10000, it has to show downwards Arrow in green color, If the value is <10000, it has to show upwards arrow in red Color.... How to achieve this?

Cap Gemini,

4 13747

Un-Answered Questions { Data Warehouse }

What do you mean by filter transformation?

948

how do you debug and test your sas programs? : Sas programming

1124

define drill through?

What is called a slice?

1028

Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

1047

Can there be sub steps of etl steps?

1028

What is an aggregator transformation?

1096

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

2012

what is $$$$?

2157

What are partition points?

1065

what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

2305

How do you optimize reports in microstartegy?

1109

Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

2228

what is chore commit property?

how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5

2109

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