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?

1223

Differentiate between a database and data warehouse?

1143

How we can use union transformation?

1051

What do you understand by a term domain?

1124

Define joiner transformation?

1049

Define enterprise data warehousing?

1204

Write the advantages of partitioning a session?

1282

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

1125

Differentiate between a repository server and a powerhouse?

1118

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

1032

What are mapplets?

1269

What are data-driven sessions?

1205

How many numbers of sessions can one group in batches?

1064

How many repositories can be created in informatica?

1 1756

Define update strategy?

1222

Un-Answered Questions { Data Warehouse }

What is difference between a gateway node and worker node?

1137

What is informatica etl tool?

999

What do you mean by caching in teradata?

1063

What are the design methods of data warehousing?

948

Explain difference between powerplay transformer and power play reports?

953

Have you used Unstructured data?

1319

What are the steps involved in the migration from older version to newer version of Informatica Server?

2107

Can you define slice?

1034

How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.

4370

how can you direct the sql generated to use a specifc table?

971

What are cluster in redshift? How do I create and delete a cluster in aws redshift?

How data is processed and what are the fundamentals of this approach?

1148

What is meant by a node?

1041

what are some differences between proc summary and proc means? : Sas programming

1127

What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

2967

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