Data Warehouse Interview Questions
Questions Answers Views Company eMail

How do you debug and test your SAS programs?

Quintiles,

1020

What can you learn from the SAS log when debugging?

Quintiles,

894

What is the purpose of _error_?

Quintiles,

1 1766

Have you ever used the SAS Debugger?

Quintiles,

1165

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

Quintiles,

1074

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

Quintiles,

1 1683

How do you test for missing values?

Quintiles,

1036

How are numeric and character missing values represented internally?

Quintiles,

1107

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

Quintiles,

3949

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,

965

what is granularity in Data ware House?

IBM,

1145

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,

1799

What is the difference between project backlog and product backlog?

IBM,

1011

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

Infosys,

963

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

837


Un-Answered Questions { Data Warehouse }

What is a conditional attribute in microstrategy?

612


Where the datastage stored his repository?

591


Explain three-tier connection?

515


Differentiate between sas functions and sas procedures.

617


sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately

3083






Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to you 

1333


What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?

1591


What is difference between join, merge and lookup stage?

614


Describe in detail about lookup?

596


What all are steps in up gradation of Informatica server?

594


How to apply securities for reports in cognos connection?

2091


how u will design the report if the objects are available

2297


what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw

1845


Can the expiration parameter of 365 in the cognos 8 configuration how to increase common symmetric key lifetime in days

3131


Explain what is informatica metadata and where is it stored?

592