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?

1125

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?

1126

Differentiate between a repository server and a powerhouse?

1118

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

1033

What are mapplets?

1271

What are data-driven sessions?

1208

How many numbers of sessions can one group in batches?

1064

How many repositories can be created in informatica?

1 1756

Define update strategy?

1227

Un-Answered Questions { Data Warehouse }

How to find value from a column in a dataset?

2203

What are the advantages of teradata?

1017

what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.

2238

I installed AbInito in my PC.In components there is no "select" component.How can i get that component?and How we can create user defined components?

2059

How can you define user defied event?

1031

What are the differences between different versions of co-op?

1004

how will you location sas platform applications available from web browser? : Sas-bi

1076

Ist the schema that a data warehouse system can implements.

941

Difference between in process and inter process?

1236

How do you manage the Parameter files while migrating your data from one environment to another environment?

1018

What is data movement mode in Informatica and difference between them?

1137

what is smart metrics in microstrategy?

1034

Explain the difference between oltp and olap?

1123

Enlist the functions performed by sas.

1128

Can you fastexport a field, which is primary key by putting equality on that key?

1178

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