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?

1311

Differentiate between a database and data warehouse?

1194

How we can use union transformation?

1106

What do you understand by a term domain?

1175

Define joiner transformation?

1107

Define enterprise data warehousing?

1259

Write the advantages of partitioning a session?

1337

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

1177

Differentiate between a repository server and a powerhouse?

1188

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

1083

What are mapplets?

1330

What are data-driven sessions?

1261

How many numbers of sessions can one group in batches?

1105

How many repositories can be created in informatica?

1 1830

Define update strategy?

1322

Un-Answered Questions { Data Warehouse }

Can you implement SCD2 using join, transformer and funnel stage?

1606

What is the length assigned to the target variable by the scan function?

1208

what is SDLC way of code development?

2097

What is the difference between set functions and filter function in dimensional data?

2958

Is it possible to create multiple domains on a single Informatica server?

1291

what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

2418

How do you ensure simultaneous releases across multiple operating systems?

1020

Where do we use mapping variables in informatica?

1124

What are junk dimensions?

1117

What is difference between custom hierarchy and report based hierarchy?

1071

explain what is data set in sas? : Sas-administrator

1042

Give the sizes of SMALLINT, BYTEINT and INTEGER.

1216

What are the performance considerations when working with aggregator transformation?

1213

What does proc print, and proc contents are used for?

1227

How might you approve all mappings in the archive all the while?

1088

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