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 are the different functions included in the server software?

995

What are the components provided on node?

995

What are the design features involved in teradata?

998

What are the different functions performed in development phase?

1033

What are the uses of client software involved in teradata?

942

What is the use of virtual processor connectivity in teradata?

962

What are the uses of bynets in multi-node systems?

984

What are the steps involved in the process flow of the sql statement through channel attached system?

1068

Describe the differences between a data warehouse and data mart.

947

Describe a data warehouse.

934

What is the main difference between star and snowflake star schema? Which one is better and why?

991

What are situations where snowflake schema is better than star schema when the opposite is true?

945

What is data cleaning? How can we do that?

1004

What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?

1042

What is a cube in data warehousing concept?

1031

Un-Answered Questions { Data Warehouse }

WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S

2219

What is the use of %include statement?

1014

How do you debug and test your SAS programs?

1522

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

1971

Mention what is a partition and what are the different types of partition components in abinitio?

1137

--------------Diff b/w ODS and OLAP?

3164

Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?

902

What is a clique?

1037

Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?

2199

Which command using Query Analyzer will give you the version of SQL server and operating system ?

4978

What are the major challenges you faced while creating the rpd?

824

Clarify the aggregator change?

990

What is cfapplication tag?

927

How the users created differs from rpd/answers/dashboards level?

783

i have a scenario where i need to change the value of a sort order in my sort component whether ascending or descending depend on some input value... e.g if input_val = A then sort order should be ascending else descending I have to use PDL in this... Can you please tell me where do i have to make this change and how ?

2028

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