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 4392

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?

1233

What is sandbox?

1206

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

1118

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

1380

What is de-partition in abinitio?

1364

What is rollup component?

1243

What is sort component in abinitio?

1224

What is a rollup component? Explain about it.

1189

How to add default rules in transformer?

1223

Define query studio?

1002

What is main difference mapplets and mapping?

1193

Define metrics studio?

1043

What are the types of studio?

1150

Un-Answered Questions { Data Warehouse }

Explain about Informatica server process that how it works relates to mapping variables?

1079

What is object stores?

984

How can I test reports in cagonos?

959

What is meant by a node?

1041

how does sas handle missing values in a merge? : Sas programming

1048

Can we create multiple integration service on single repository?

1187

how will you implement security in obiee,so that subjects areas accessed by one group are not accessed by another group.

871

Difference between inner join and outer join?

1025

What is the difference between Data Warehousing and Data Mining?

1055

How to load data in informatica ?

1021

What do you mean by derived metrics?

996

How do dates work in SAS data?

1176

what are the criteria used by the microstrategy sql engine to build the join tree of a report’s sql?

951

What is by-group processing?

997

Explain me ETL project architecture in Detail?

2369

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