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 we can create indexes after completing the load process?

1160

What is the surrogate key?

1261

Why is sorter an active transformation?

1129

Define sessions in informatica etl?

1034

Define filter transformation?

1096

What is meant by a domain?

1126

What is the benefit of partitioning a session?

1182

Explain the difference between mapping parameter and mapping variable?

1038

What are the various types of transformation?

1179

Write the prerequisite tasks to achieve the session partition?

1158

What is the reusable transformation?

1047

What is meant by active and passive transformation?

1125

What is the difference between a repository server and a powerhouse?

1513

Define mapplet?

1008

Explain the scenario which compels informatica server to reject files?

1168

Un-Answered Questions { Data Warehouse }

What is program data vector (pdv) and what are its functions?

1246

name some data transformation used in sas di? : Sas-di

972

Describe data concatenation?

1082

Did you used proc test? when?

2039

What is the command used to find missing values?

1100

Explain the difference between oltp and olap?

1122

Is there a difference between view filter and report filter?

920

what is power prompt in cognos ep7series?what is the use of this?

3689

How many ways are there to do 'remove duplicate records in informatica'?

1014

Can we change Dynamic to Static or Persistent cache? If so what happens?

2210

In SAS explain which statement does not perform automatic conversions in comparisons?

1312

explain the key concept of sas? : Sas-administrator

1005

To see hidden files in LINIX?

1529

how to perform single sign in cognos by using url?

1154

Explain the different kinds of facts.

981

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