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 are the transformations that restricts the partitioning of sessions?

1 9078

What is Performance tuning in Informatica?

CTS, GE, TCS,

1 43727

What is power center repository?

1 11893

How can u work with remote database in informatica?did you work directly by using remote connections?

2 8845

What are the new features in Informatica 5.0?

1 4898

what is incremantal aggregation?

1 6133

What are the scheduling options to run a sesion?

2 11619

What is difference between stored procedure transformation and external procedure transformation?

2 14564

Explain about Recovering sessions?

1 6196

If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?

4 19099

How to recover the standalone session?

2 7260

How can you recover the session in sequential batches?

1 9810

How can you complete unrcoverable sessions?

1 5600

What are the circumstances that infromatica server results an unreciverable session?

1 5332

If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?

2 7927

Un-Answered Questions { Data Warehouse }

What is report as filter in microstrategy?

960

what is the use of backward drilling in cognos 8?is it possible?whats the uws of it?

2142

Explain security filter?

1125

State the difference between INFORMAT and FORMAT ?

1156

how can you direct the sql generated to use a specifc table?

1019

Describe the process steps you would perform when defragmenting a data table. Does this table contain mission-critical data?

1097

What are differences between teradata and ansi session modes in teradata?

1226

What are the join problems comes appart from loop,chasm & fan Traps

2200

How to restrict password to a user while sending a document in .pdf format

2406

my report ended at the half of the last page but i don't want that matter in the last page I would like to adjust the matter in the previous page .how can i do this?

2052

What are the various indexes in teradata?

1112

What are all the components of Report Studio?

1162

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

2178

how to run a sequential file stage in parallel if the stage is used on the TARGET side

1801

what is document design in boxi,have u participate in that

2284

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