1. Categories >> Software >> Data Warehouse
  2. Suggest New Category


Data Warehouse Interview Questions
Questions Answers Views Company eMail

How do you debug and test your SAS programs?

Quintiles,

1036

What can you learn from the SAS log when debugging?

Quintiles,

908

What is the purpose of _error_?

Quintiles,

1 1790

Have you ever used the SAS Debugger?

Quintiles,

1201

How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?

Quintiles,

1086

How many missing values are available? When might you use them?

Quintiles,

1 1701

How do you test for missing values?

Quintiles,

1051

How are numeric and character missing values represented internally?

Quintiles,

1128

This entry was posted in General. Bookmark the permalink. Post a comment or leave

Quintiles,

4011

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,

980

what is granularity in Data ware House?

IBM,

1160

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,

1826

What is the difference between project backlog and product backlog?

IBM,

1019

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

Infosys,

978

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

 846

Un-Answered Questions { Data Warehouse }

what is the cube size?

5

Suppose you find the term validation mentioned with a set of data, what does that simply represent?

576

What are the steps to create a repository in ab initio?

743

How to deploy from one server to another server?

2007

How do you define Teradata?

600




what is repositery?

1284

how to change the execute of macro

1659

What is conduct>it?

624

Explain fact relation?

572

Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks

1363

What are the benefits of datastage?

716

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

5751

I need to set predefined condition. How I do this?

499

What do you understand by the term 'dynamic cube'?

558

if collect stats but it show low confidence why?

1176

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