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 sas data set?

1106

How will you generate test data with no input data?

1173

What is the difference between input and infile statement?

1175

What is the difference between reading data from an external file and reading data from an existing data set?

1175

Describe the ways in which you can create a macro variable?

1084

Mention the category in which sas informats are placed?

1020

How substr function works in sas?

1222

What is the difference between informat and format statement?

1 1661

How do dates work in sas?

1139

What is the difference between the proc sql and data step?

1174

What is the good sas programming practices for processing large data sets?

1114

What is the difference between where and if statement?

1113

What are the different types of sas functions?

1284

Mention common programming errors committed in sas ?

1126

What is by-group processing?

997

Un-Answered Questions { Data Warehouse }

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

2122

List down some of the real time data-warehousing tools?

972

Compare dataset and fileset?

1039

how we can generate cubes in cognos?

How would you declare an inline css to format the table with a background color of yellow and give the table cell a right margin of 10 pixels?

937

What are the steps involved in the migration from older version to newer version of Informatica Server?

2109

What is freehand sql?

1044

Name the different lookup cache(s)?

1234

What are prompted filters? Have you ever used them? Where?

986

What is the difference between informatica 7.0 and 8.0?

1016

What is the difference between group and associare?

1048

What is the difference between global temporary tables and volatile temporary tables?

1182

Ist the schema that a data warehouse system can implements.

941

Can anyone give me an exaple of realtime start script in the graph?

1055

What is broadcasting and replicate?

1171

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