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 4252

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

1224

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

1185

What is sandbox?

1152

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

1073

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

1280

What is de-partition in abinitio?

1331

What is rollup component?

1185

What is sort component in abinitio?

1182

What is a rollup component? Explain about it.

1131

How to add default rules in transformer?

1176

Define query studio?

962

What is main difference mapplets and mapping?

1114

Define metrics studio?

988

What are the types of studio?

1108

Un-Answered Questions { Data Warehouse }

Write the unconnected lookup syntax?

1043

What is initial load and what is full load?

917

What is meant by a Least Cost Plan?

1013

Explain the architecture of obiee and what each components do?

796

What condition do we use in Cognos when multiple path exits to reach the fact table.(i.e in BOXI we use CONTEXT when multiple path exit)

2092

How you prepared reports for OLAP?

1562

How to schedule the report in b.o?

965

What do you understand by overflow errors?

1173

In the Primary Index, what is the score of AMPs that are actively involved?

1019

How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

1101

What is the importance of having monitor service in cognos?

994

List out some of the air commands used in abintio?

1344

What do you know about abinitio?

1209

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

2106

Can a dimension table contain numeric values?

1014

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