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

Explain ddl (data definition language)?

1048

Explain how to generate iqd file from framework manager?

995

How to limit the max no of rows retrieved in the report?

1031

Code the tables statement for a single-level (most common) frequency?

973

What is perform recovery?

1192

Can we start and stop single session in concurent bstch?

984

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?

1165

How to provide security in frame work manager for a query subject?

1010

How to improve session performance in aggregator transformation?

1028

Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?

1068

What is a functional dependency f said to be minimal?

1162

How to eliminate duplicate rows from flat file?

989

How to generate the cubes in framework manager?

1098

What are target types on the server?

1038

What is difference between model & package?

1082

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What is loop in data warehousing?

1199

How can we schedule the graph in unix?

1041

What are the tools available for etl?

1024

What does level of granularity of a fact table signify?

1151

What is the extension of file to save template?

1054

what type of raid setup would you put your tx logs?

995

What is a data profile?

1024

How to generate the cubes in framework manager?

1098

What is called dimensional modelling?

1183

Explain the difference between data ware house & data mart?

1022

Explain what are the different types of data warehousing?

1005

What is the 4 + 1 view model as it relates to system modeling?

1097

Explain meta data?

1108

What is the difference between star and snowflake schemas?

1317

What is the advantages data mining over traditional approaches?

1023

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