Data Warehouse General Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Data Warehouse General Interview Questions

Questions Answers Views Company eMail

Start a batches with in a batch?

935

How to create different types of templates?

940

What is the difference between connected and unconnected stored procedures?

998

What is a relationship?

939

Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?

909

Where the applications and where

880

How many project sources we can create in metadata?

1021

What is the difference between static cache and dynamic cache?

938

ware house management system is used?

950

What function should we use to display the value entered or selected by a user in response to a prompt?

932

What are partition points?

999

How can we transform row to column?

1 1396

How to stop a batch?

920

How to allow a dynamic selection of a column for a measure in a chart,without using variable?

933

If two relational tables are connected to sq trans, what are the possible errors it will be thrown?

907

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

Explain when do we analyze the tables? How do we do it?

946

Can you pass sql queries in filter transformation?

965

What is incremintal loading?

1037

what is difference between drill & scope of analysis?

1001

Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?

1030

How to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?

862

what are the different views that are considered when building an object-oriented software system?

985

What are fundamental stages of data warehousing?

1000

Explain the data type of the surrogate key?

910

How to add a number to a macro variable?

948

What are the data marts?

926

What is analytical or analytic mean?

1072

Explain a relation schema and a relation?

1044

How can we do data cleaning?

995

Which are the olap tools available that are supported by oracle?

895

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