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

explain the difference between proc means and proc summary?

1184

Mention the difference between ceil and floor functions in sas?

1216

How to include or exclude specific variables in a data set?

1169

What is substr function?

1249

why a stop statement is needed for the point= option on a set statement?

1139

How can sas program be validated?

1077

Mention how to limit decimal places for the variable using proc means?

1176

What is a put statement?

1276

How to read an input file in sas?

1194

How sas treats the dsd delimiters?

1266

How can you limit the variables written to output dataset in data step?

1385

how to remove duplicates using proc sql?

1203

How to display duplicate observations in data?

1 1747

What are common programming errors committed in sas

1190

What are the difference between ceil and floor functions in sas?

1407

Un-Answered Questions { Data Warehouse }

What we will do with the universe for faster process?

1036

name the sub-tabs which are in advance tab of ti?

Can you define a query subject?

1066

what is the use of backward drilling in cognos 8?is it possible?whats the uws of it?

2136

how do u really know that paging to disk is happening while u are using a lookup transform?

2043

which one is better performance wise joiner or look up

1155

What is the difference between class statement and by statement in proc means?

1399

Mention a few design and development best practices for informatica?

1047

What are the functions used for character handling?

1315

What are the different methods of loading dimension tables?

1044

how do u implement configuration management in Informatica?

4841

explain abt ur project architecture?

2237

Name the five phases that come under MultiLoad Utility.

1032

What is incremental aggregation?

1138

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2783

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