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

What is a node in Informatica?

1046

What is native users?

1174

How would you copy the content of one repository to another repository?

1027

What is an Integration service in Informatica?

1143

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

1146

What is a code page?

1182

What is DR strategy for Informatica project?

1195

difference between repository database and repository service?

1160

Is it possible to define a single node as a Gateway node as well as worker node?

1129

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

1250

Can we create a node as a gateway node and the same node can be assigned to a grid?

1085

What is difference between a gateway node and worker node?

1147

Is it possible to revert a global repository to local one and why?

1088

How do you migrate data from one environment to another?

1103

Can we create two repositories on same database instance in oracle?

1105

Un-Answered Questions { Data Warehouse }

What is a lookup table in etl?

1195

What are the names of the layers in etl?

1004

how to create metric universe ?

2355

Difference between b.o 5.1 and 6.1b?

1265

What is powercenter on grid?

1190

What is the difference between Data Warehousing and Data Mining?

1062

What is spool space? Why do you get spool space errors? How do trouble-shoot them?

994

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

2219

What does reusable transformation mean?

1142

Is microstrategy desktop available in other languages?

1016

Explain informatica architecture?

1006

How can we use batches?

1031

How to Create a folder using pmrep command?

1182

What are the important features of datastage?

1129

How can we Maintain the Cube Security by Category level and Dimension level ?

2368

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