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

Teradata (490)
Business Objects (875)
Cognos (1143)
Informatica (2428)

SAS (1049)
Micro Strategy (282)
ETL (315)
OBIEE (92)

Data Warehouse Interview Questions

Questions Answers Views Company eMail

What is the pound sign used for in the data_null_ ?

1 3596

For what purpose(s) would use the RETURN statement?

1 8102

How would you determine how far down on a page you have printed in order to print out footnotes?

3 9770

How would you include common or reuse to be processed along with your statements?

2393

Why is a STOP statement needed for the point=option on a SET statement?

Quintiles,

2 13140

How would you remove a format that has been permanently associated with a variables?

3 10334

Briefly describe 5 ways to do a "table lookup" in sas.

Quintiles,

4 21205

If you were told to create many records from one record show how you would do this using arrays and with PROC TRANSPOSE?

HCL, Quintiles,

1 9582

How can you put a "trace" in your program?

Quintiles,

2 10779

Are you sensitive to code walk-throughs peer review or QC review?

Quintiles,

3156

What other SAS features do you use for error trapping and data validation?

2 12274

What has been your most common programming mistake?

Wipro,

4 11206

Which date functions advances a date time or date/time value by agiven interval?

3 7913

How would you keep from overlaying the a SAS set with its sorted version?

4 9712

Explain the message 'Merge has one or more datasets with repeats of by variables'.

5 21047

Un-Answered Questions { Data Warehouse }

Can a dimension table contain numeric values?

1073

What is the difference between round-robin partitioning and hash partitioning?

983

Is there any target staging area in informatica not staging area

2588

How do you improve the performance of a graph?

1164

What is sandbox?

1224

What are attribute roles?

987

Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar

1990

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

3597

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

1291

What is the purpose of trailing @ and @@? How do you use them?

1049

What is the difference between where and if statement?

1123

what is sysdba and sysdbc ? which has high priority ?

3843

Mention a few of the ETL tools that come under Teradata.

1098

How to read the length of word in unix?

1390

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

1110

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