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 tracing level? How many types of transformations supported by sorted input?

932

What is a rollup component?

1094

What is the function of aggregator transformation?

1040

What are the different options available for update strategy?

961

What is the function of union transformation?

1081

What is meant by query override?

1021

What are different types of transformations available in informatica?

955

What is the difference between a connected look up and unconnected lookup?

925

What is the use of source qualifier?

1086

What is the function of look up transformation?

1073

What is the use of transformation?

963

What is the use of code page?

1031

What does reusable transformation mean?

1087

What is main use of mapplet?

1088

What is the way to execute pl/sql script using informatica mapping?

1536

Un-Answered Questions { Data Warehouse }

explain about data integrator metadata reports? : Sas-di

1056

What is static and local variable?

992

What are stage variables, derivations and constants?

1176

what is microstrategy narrowcast server?

1086

Explain the difference between holap and molap?

1007

What are the key features of chameleon that separates it from other algorithms?

1077

how to generate the test data in sas without input data? : Sas-administrator

1075

What are the features of complex mapping?

1110

what is the output when -1 is put in select_expr of FBE?

1382

What are the different types of scd's used in data warehousing?

1198

explain what is factor analysis? : Sas-administrator

1065

What are symget and symput? : sas-macro

1264

Does an informatica transformation support only aggregate expressions?

991

What is set to be Cognos configuration?

984

What is the difference between informatica 7.0 and 8.0?

964

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