Data Warehouse Interview Questions
Questions Answers Views Company eMail

What is fact extension?

595

Explain the Roles in mstr?

544

How does microstrategy object manager integrate with the microstrategy product suite security model?

555

What is dynamic aggregation in microstrategy?

559

What is scanmd and md doctor?

642

Can the administrator easily maintain and manage microstrategy intelligence server?

547

What is derived metric?

587

What is a security filter in microstrategy?

563

What are logical views used for in microstrategy?

534

What are public objects?

637

What is the difference in the way microstrategy handles custom group and consolidations?

561

How conflicts occur and what are the ways to resolve them?

531

What are configuration objects?

601

What are the enhanced features in teradata v2r5 and v2r6?

695

Explain Teradata performance tuning and optimization?

703


Un-Answered Questions { Data Warehouse }

What is the difference between look-up file and look-up, with a relevant example?

700


Diff b/w Crossproduct and Outerjoin?

1813


What is repository manager?

536


How is the number of passes in a sql query significant in performance evaluation?

530


Given input file with single column having 1 2 2 4 3 .. Required output 1 2 2 4 4 4 4 3 3 3.. How?

534






What is your favorite all time computer book? Why?

2048


What is tracing level and what are the types?

537


How do you setup Lo-cockpit?

2632


What are the key elements of a data processing system?

690


If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1033


What are the benefits of using AWS Redshift?

5


What are key differences between sql server and amazon redshift?

1


What are the tasks that can be performed using sq?

615


Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?

1467


What is powercenter on grid?

695