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,

3349

what is amp plz explanation

IBM,

5 8592

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

Wipro,

2 7403

Why we use ENABLE HIGH PRECISION in session properties?

Cognizant,

2 14342

why dataset ?

2 6019

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 5477

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

1 6133

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 10258

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

WNS,

1 7727

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 8106

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 7802

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 7089

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

3180

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

2357

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 13778

Un-Answered Questions { Data Warehouse }

What is the use of aggregation when we have rollup as we know rollup component in abinitio is used to summarize a group of data record? Then where we will use aggregation?

1278

How to generate sequence numbers using expression transformation?

1103

What is prompt types of prompts?use of prompts syntax of prompt?

1354

Can you define folder?

974

1.Have u logical models in project? If s which logical model used? 2.how do u connect to production server? 3. how do u test the data in report is same as in DWH? 4. u created one report but there is no data in the attribute. But how can u extract the data from ware house? 5. u have two tables having different ids how do u merge those table in MSTR? 6. have u faced challenging situation in u r project? Give me one example?

2582

What are some examples of informatica etl programs?

954

what are the deliverables?in your project?

2161

What is etl process? How many steps etl contains?

1047

How to improve the performance of a session using sorter transformation?

1163

Which version configuration tool used in ur project?

3276

Explain er diagram?

1001

What is dimensional table? Explain the different dimensions.

1181

Do you find any difficulty while working with flat files as source and target?

1113

What is MODEL is Data mining world?

2627

What is a transaction control transformation?

1222

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