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 are the features of base sas system?

1 1121

What are the advantages of using sas?

1 1198

What is the difference between %local and %global?

1 1733

What are the ways to do a “table lookup” in sas?

1 1087

What are the default statistics that proc means produce?

1 1099

What are the uses of sas?

1 1375

Why and when do you use proc sql?

1 1294

What are the scrubbing procedures in sas?

1 1067

What are the statements that are executed only?

1 1218

What is the difference between match merge and one to one merge?

1 1334

What are the statements in proc sql?

1 1157

What is the use of the %include statement?

1 1226

If you were told to create many records from one record, show how you would do this using array and with proc transpose?

1 1559

What sas features do you use to check errors and data validation?

1 1279

How to limit decimal places for the variable using proc means?

1 1133

Un-Answered Questions { Data Warehouse }

What is dimensional table? Explain the different dimensions.

1262

Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani

2338

What is rollup component?

1324

How would you format some text using css to be verdana and bold?

1133

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

hi i want to learn microstratogy please anyone help to me which institute is best in bangalore any one having related documents ,and video link please mail to this id avanthireddykv@gmail.com

2289

Explain how to generate iqd file from framework manager?

1010

How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1839

Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks

2087

can any one help me now i am learning AB Inito but i don't have material and pdf's can any one provide pdf's to this mail id mohanraju0113@gmail.com thanks in advance...................................

2324

hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com

1993

faq's on cognos

4108

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

1654

can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance

2298

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

2250

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