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

Separate from an archive server and a powerhouse?

963

Make a note of the quantity vaults made in informatica?

988

How is union transformation utilized?

1009

What is meant by incremental aggregation?

1106

Different qualification between a related rotate toward the sky and isolates look upward?

986

Clarify the aggregator change?

1029

What is joiner change?

1147

What is lookup change?

1048

How might one distinguish in the case of mapping is right or not without associating session?

1120

What does cheating measurement mean?

1062

Separate from a database, an information bazaar, and an information stockroom?

1089

What is depict expression change?

1120

What is intricate mapping?

1203

Clarify the utilization of aggregator cache record?

1001

What does refresh system mean, and what are its distinctive choice?

1181

Un-Answered Questions { Data Warehouse }

Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?

975

How can I schedule reports in cognos?

1008

Which sql query platform are you using to communicate with redshift?

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

2122

What is the extension of file to save template?

1007

How to read an input file in sas?

1143

What are the different kinds of views available in a datastage director?

1030

What is the use of incremental aggregation? Explain me in brief with an example?

1023

Which of the end-user items leverage olap services?

891

What is metric store database?

1000

What are aggregate tables? How do you design them using teradata?

1170

How do you add default rules in transformer?

1223

What is an aggregator transformation?

1096

What is update strategy transform?

1102

Explain in detail scd type 2 through mapping.

1041

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