Data Warehouse Interview Questions
Questions Answers Views Company eMail

What are parallel querys and query hints?

1769

DWH architecture?

6 16032

What are cursors?

4 7306

Advantages of de normalized data?

2 10192

What is operational data source (ODS)?

2 9257

What is meta data and system catalog?

1831

What is factless fact schema?

2 5632

What is confirmed dimension?

JPMorgan Chase,

7 13888

What is the capacity of power cube?

2 5700

Difference between PowerPlay transformer and power play reports?

CTS,

2036

What is IQD file?

1 4756

What is Cognos script editor?

2055

What is difference macros and prompts?

1691

What is power play plug in?

3 3612

Which kind of index is preferred in DWH?

1 7872


Un-Answered Questions { Data Warehouse }

How do you load only null records into target?

715


What are snapshots? What are materialized views & where do we use them?

506


How to generate a report by getting values from two reports. The generated report should contain the 5 values of first report and last 5 values of second report?

523


What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?

657


To see hidden files in LINIX?

914






What is the differnce between SDTM 3.1.2 to 3.1.1 version

4576


Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks

6295


What are types of batch available in cognos?

539


What is initial load and what is full load?

494


how do u extract data from different data sources explain with an example?

1759


I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

1557


To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

649


How many types of nodes supported by Redshift and what are the functions of nodes?

5


Explain the term 'row' related to relational database management system?

512


How we are going to decide which schema we are going to implement in the data warehouse?

466