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 new features of the server manager in the informatica 5.0?

1 6420

What is metadata reporter?

Informatica,

1 8418

Define maping and sessions?

3 8844

Which tool yoU use to create and manage sessions and batches and to monitor and stop the informaticaserver?

4 9072

Why we use partitioning the session in informatica?

2 14168

To achieve the session partition what r the necessary tasks u have to do?

1 6855

How the informatica server increases the session performance through partitioning the source?

1 9018

Why you use repository connectivity?

Yash Technologies,

3 8560

What are the tasks that Loadmanger process will do?

1 5631

What is DTM process?

4 21356

What are the different threads in DTM process?

1 6442

What are the data movement modes in informatcia?

1 8113

What aer the out put files that the informatica server creates during the session running?

4 19498

In which circumstances that informatica server creates Reject files?

2 8121

What is polling?

1 7368

Un-Answered Questions { Data Warehouse }

Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?

950

Explain what are the various etl tools in the market?

950

What is difference between e-r modeling and dimensional modeling?

930

What are data validation strategies for data mart validation after loading process?

1022

what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.

2240

Can we start and stop single session in concurent bstch?

948

what is the use of proc contents and proc print in sas? : Sas-administrator

1065

What are the key features of chameleon that separates it from other algorithms?

1121

how will you locate the sas platform applications? : Sas-bi

1035

What is microstrategy desktop?

1033

What dedup-component and replicate component does?

1282

explain what is data set in sas? : Sas-administrator

993

What all the types of jobs you developed?

1181

How can we improve session performance in aggregator transformation?

1123

What is flow buffering ? How it reduces the chances of having deadlock ? How to use in abinitio graph?

3461

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