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

How can we delete duplicate rows from flat files?

1166

Differentiate between a database and data warehouse?

1093

How we can use union transformation?

997

What do you understand by a term domain?

1066

Define joiner transformation?

992

Define enterprise data warehousing?

1135

Write the advantages of partitioning a session?

1213

Under what condition selecting sorted input in aggregator may fail the session?

1063

Differentiate between a repository server and a powerhouse?

1048

Explain sessions. Explain how batches are used to combine executions?

959

What are mapplets?

1220

What are data-driven sessions?

1148

How many numbers of sessions can one group in batches?

1019

How many repositories can be created in informatica?

1 1666

Define update strategy?

1118

Un-Answered Questions { Data Warehouse }

Is microstrategy desktop available in other languages?

965

Mention the procedure via which, we can run Teradata jobs in a UNIX environment.

937

Write some methods to apply securities in framework manager model?

1049

At which levels you can set the vldb properties? Which level has the highest pecedence?

903

Give a justifiable reason why Multi-load supports NUSI instead of USI.

1084

what is slowly changing dimension? : Sas-di

1072

Briefly define a session task?

1062

what is the one statement to set the criteria of data that can be coded in any step? : Sas programming

1096

What are the different types of repositories created using informatica?

1065

How long can a macro variable be? A token? : sas-macro

1160

What do you mean by trimming sql in microstrategy?

944

What are the methods by which it non-durable model could be changed into the durable model?

906

What are the data types that sas contain?

1124

What is real time and near real time data warehousing?

1067

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

981

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