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,

3412

what is amp plz explanation

IBM,

5 8761

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

Wipro,

2 7507

Why we use ENABLE HIGH PRECISION in session properties?

Cognizant,

2 14460

why dataset ?

2 6134

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 5570

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

1 6194

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 10464

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

WNS,

1 7775

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 8242

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 7999

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 7212

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

3227

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

2393

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 13957

Un-Answered Questions { Data Warehouse }

How do you create tables? Exact syntax, and create profiles, users in teradata?

1094

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

2069

What are objects?

1062

What are the factors on which storage of data depends?

1212

List out some of the air commands used in abintio?

1439

How co> operating system natively processes the data?

1151

What is data caches/ index caches?

1178

What is informatica?

1227

Does redshift support unstructured data?

What are global filter and how they differ from column filter?

1042

What exactly do you know about the typical data analysis?

1158

What do you mean by filter transformation?

1009

What is the function of cognos dispatcher?

1289

What are the main features of datastage?

1372

how are numeric and character missing values represented internally? : Sas programming

1205

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