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?

1153

How will you generate test data with no input data?

1234

What is the difference between input and infile statement?

1232

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

1232

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

1135

Mention the category in which sas informats are placed?

1084

How substr function works in sas?

1273

What is the difference between informat and format statement?

1 1746

How do dates work in sas?

1193

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

1225

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

1180

What is the difference between where and if statement?

1153

What are the different types of sas functions?

1369

Mention common programming errors committed in sas ?

1175

What is by-group processing?

1060

Un-Answered Questions { Data Warehouse }

What is the difference between filter and lookup transformation?

1182

Explain the importance of surrogate key in data warehousing?

1237

What are pass-through functions and why they are so called? Give some examples.

1110

What happens when we provide null key to sort, merge and pbks in Abinitio ?

1748

explain in detail about type 3?

1073

Describe the function and untility of the most difficult SAS macro that you have written.

2171

Define Pmrep command?

1118

what is flow of project?

2061

what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

1462

Explain do we need an etl tool?

1076

what are the different types of fact structures?

1160

Whats difference betweeen operational data stage (ods) and data warehouse?

1172

Input Data: AAABBBCC CCAAABB expected output A3B3C2 A3B2C2 How can I achieve this in Ab initio? where In output count of occurrences should be sorted from high to low

1542

The methods to improve performance of a graph?

1132

When to use local filter and when to use global filter?

1065

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