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 commands are used in the case of including or excluding any specific variables in the data set?

1109

What are the 3 components in sas programming?

1208

Explain the purpose of retain statement.

1079

Why double trailing @@ is used in input statement?

1238

Explain the special input delimiters used in sas programming.

1021

What are the ways in which macro variables can be created in sas programming?

1124

Which command is used to perform sorting in sas program?

1060

What are the data types that sas contain?

1204

Explain the difference between nodup and nodupkey options?

1044

Differentiate between sas functions and sas procedures.

1258

Explain the difference between informat and format with an example.

1184

Differentiate between proc means and proc summary.

1074

Explain data_null_?

1068

Enlist the functions performed by sas.

1146

What is the purpose of _character_ and _numeric_?

1080

Un-Answered Questions { Data Warehouse }

Runtime behavior of Normalize and Reformat

2727

Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?

1028

webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??

4416

Do you know the features of sas?

1058

Can you define a query subject?

1030

What are the batches and it’s details?

986

Explain have you ever been in a real dilemma at work? What did you do to get out of it?

976

What do you mean by dimensional modeling and relational modeling? Which one do you use in dw? Why?

968

What are teradata utilities?

1122

What is the difference between Open Connection command ang Open Session Command?

2459

What are the key columns in Fact and dimension tables?

993

What are the components of the workflow manager?

1152

explain abt ur project architecture?

2205

What you will do when your report is not fetching right data?

935

Where we use afc in actuate?

1042

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