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,

1050

What can you learn from the SAS log when debugging?

Quintiles,

921

What is the purpose of _error_?

Quintiles,

1 1814

Have you ever used the SAS Debugger?

Quintiles,

1211

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

Quintiles,

1105

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

Quintiles,

1 1720

How do you test for missing values?

Quintiles,

1062

How are numeric and character missing values represented internally?

Quintiles,

1141

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

Quintiles,

4054

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,

998

what is granularity in Data ware House?

IBM,

1165

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,

1844

What is the difference between project backlog and product backlog?

IBM,

1032

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

Infosys,

986

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

 860

Un-Answered Questions { Data Warehouse }

What are the components used in smp and massively parallel processing (mpp) machines?

603

What is the general format of function in sas? : sas-grid-administration

573

What is a linked cube?

539

How we can covert server job to a parallel job?

601

what are the deliverables?in your project?

1665




How to sort the dynamic objects alphabetically on the Universe based on and SQL Server

1821

why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.

1540

Fact table is in normalized or de-normalized form?

544

Connecting to iserver volume using idapi classes(java classes) and after connecting to iserver I want to execute the rox on iserver and also want know the status whether that job is succesfully run or not?

583

Can you define dimension?

641

Performance tuning( what you did in performance tuning)

1489

What is persistent lookup cache?

607

what is the difference between usersandbox,privatesandbox,publicsandbox,commonproject sandbox?

3386

Explain Association algorithm in Data mining?

1868

What is the purpose of cluster analysis in data warehousing?

567

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