Data Warehouse Interview Questions
Questions Answers Views Company eMail

Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?

707

What is difference between primary key and unique key constraints?

657

Define query items?

678

What are the different uses of a repository manager?

683

Define dimensions?

706

Why need staging area database for dwh?

739

What are shortcuts? Where it can be used? What are the advantages?

636

Give the advantages of cognos?

670

Name the types of gateway?

683

Explain the characteristics of cognos?

688

Name the types of report?

636

What are the advantages of shortcuts?

614

Define olap designer?

790

Define report item?

764

Can you define drill across?

643


Un-Answered Questions { Data Warehouse }

Explain about round-robi?

738


Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro

808


How do you use the do loop if you don’t know how many times you should execute the do loop?

867


Why is dimensional normalization not required?

729


what is smart metrics in microstrategy?

696






how to create cubes in transformer ?

717


What do you mean by teradata intellicloud?

679


What is the syntax for case when statement?

678


What are the fundamental elements of the data warehouse?

580


Explain and compare etl & manual development?

597


How we can create SAS USER DEFINED CODE?

1717


i want for interview question & answer plz it need immediate send t my mail raviprakashmot@gmal.cm

2001


What are the three tiers in etl?

681


I have two universes created by two difference database can we join them in designer & report level? How

611


How many types of views are there in a datastage director?

938