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)?

1016

Explain how to generate iqd file from framework manager?

950

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

986

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

939

What is perform recovery?

1111

Can we start and stop single session in concurent bstch?

948

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?

1101

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

964

How to improve session performance in aggregator transformation?

988

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?

1024

What is a functional dependency f said to be minimal?

1068

How to eliminate duplicate rows from flat file?

944

How to generate the cubes in framework manager?

1048

What are target types on the server?

998

What is difference between model & package?

1038

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What is data analysis? Where it will be used?

989

Explain functional dependency?

1095

What is the very basic difference between data warehouse and operational databases?

973

How would you write a left join statement to return a result set of movie.title�s and director.name�s?

1030

What is the extension of file to save template?

1009

What is a hash cluster?

990

What is the difference between constraind base load ordering and target load plan?

1124

Explain what are the modules in power mart?

1052

Why fact table is in a normal form?

997

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

930

How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?

954

What is is a star schema?

1179

How to handle multi value dimensions?

2298

hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit

2052

What is vdl (view definition language) explain?

1053

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