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 you connect eme to abinitio server?

1 4391

What is a partition and what are the different types of partition components in abinitio?

1273

What information does a .dbc file extension provides to connect to the database?

1232

What is sandbox?

1205

Explain how you can run a graph infinitely in ab initio?

1118

What is the difference between partitioning with key / hash and round robin?

1378

What is de-partition in abinitio?

1363

What is rollup component?

1243

What is sort component in abinitio?

1222

What is a rollup component? Explain about it.

1186

How to add default rules in transformer?

1223

Define query studio?

1000

What is main difference mapplets and mapping?

1193

Define metrics studio?

1043

What are the types of studio?

1148

Un-Answered Questions { Data Warehouse }

What is informatica etl tool?

999

Your colleague installed microstrategy on solaris or unix without root access. Will he be able to start/ restart this server?

968

What are the supported languages for microstrategy intelligence server?

1011

Explain attribute role?

1079

What are the fundamental blocks of co> operating system of ab initio?

1268

List down some of the real time data-warehousing tools?

972

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

7062

What is informatica metadata and where is it stored?

991

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

1148

What are the various kinds of containers available in datastage?

1048

Explain what is a staging area? Do we need it? What is the purpose of a staging area?

961

Explain what is a cube in data warehousing concept?

985

What is purpose of having conditionality in metrics in microstrategy?

978

Briefly define a session task?

1130

Suggest a good author for hyperion in data warehousing?

965

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