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

Which are the statements whose placement in the data step is critical?

1321

What is the basic structure of a sas program?

1179

What does the trace option do?

1167

How to test the debugging in sas?

1251

How to create a permanent sas data set?

1323

What do the sas log messages “numeric values have been converted to character” mean? What are the implications?

1259

What is the use of %include statement?

1119

What is a pdv and what are its functions?

1229

What are the data types in sas?

1118

What is the use of stop statement?

1126

What is the basic syntax of a sas program?

1273

How would you define the end of a macro?

1161

What are the difference between the sas data step and sas procs?

1263

I have a dataset concat having a variable a b & c. How to rename a b to e & f?

1353

Difference between SAS STATA & SPSS?

1184

Un-Answered Questions { Data Warehouse }

What are the different table types supported by teradata?

1024

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

2079

Can you define metrics designer?

1113

What is the function of Stop statement in a SAS Program?

1206

what are the different types of tests done on a microstrategy report?

953

Why do you get spool space errors? How do trouble-shoot them?

1103

What is the function of etl when used in data warehousing?

1009

I'm busy writing a report that's using report bursting, to be able to do this I need to use a sequential section. Using a sequential section cause the grouping of the original report not to work. Please can someone give me advise on how to come past this problem, the report need to use grouping as it depend largely on totals ect, and I need to use a sequential section within the report to be able to use the report bursting facility.

2818

How to load the data from a flat file into the target where the source flat file name changes daily?

1108

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

2111

Describe the evaluation of parameters order in ab initio?

1581

What is the difference between informatica 7.0 and 8.0?

1063

What is the different between functions and PROCs that calculate the same simple descriptive statistics?

1850

Explain what Proc glm does?

1308

How can sas program be validated?

1083

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