Data Warehouse Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Design a mapping to calculate department wise sum of salaries and load it in single target? Source Target Deptno Salary Deptno Salary 10 100 10 600 10 200 10 600 10 300 10 600 20 200 20 800 20 300 20 800 20 300 20 800 30 400 20 1500 30 500 30 1500 30 600 30 1500

Cap Gemini,

1498

what is granularity in Data ware House?

IBM,

1724

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

Cap Gemini,

2421

What is the difference between project backlog and product backlog?

IBM,

1533

SCD2 will work on only dimension tables as well as fact Table?

Infosys,

1401

Which transformation we use to convert 'NA' to 'Not Available'

1268

Un-Answered Questions { Data Warehouse }

Is possible to create skid in dim,fact tables?

2636

How we drill up week to month?

1077

What is the difference between %put and symbolgen? : sas-macro

1238

How co> operating system natively processes the data?

1098

How will I be charged and billed if I use Amazon Redshift?

What is data encoding?

1260

Differentiate between validated and Compiled in the Datastage?

1282

what is the use of materialized view?

1571

What is crass reference table?

1054

Describe how you would ensure that database object definitions (tables, indices, constraints, triggers, users, logins, connection options, and server options etc)are consistent and repeatable between multiple database instances (i.e.: A test and production copy of a database)?

1151

What are the different softwares used with their functions in teradata?

1015

Explain 4gt switch?

899

Of all your work, where have you been the most successful?

4669

What is many-to-many dimensional model in datawarehousing ?

936

Which statement does not perform automatic conversions in comparisons?

1786

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