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?

1032

What are the components provided on node?

1042

What are the design features involved in teradata?

1057

What are the different functions performed in development phase?

1080

What are the uses of client software involved in teradata?

984

What is the use of virtual processor connectivity in teradata?

1026

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

1030

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

1104

Describe the differences between a data warehouse and data mart.

1001

Describe a data warehouse.

988

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

1035

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

981

What is data cleaning? How can we do that?

1044

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?

1103

What is a cube in data warehousing concept?

1074

Un-Answered Questions { Data Warehouse }

State the working process of decimal_strip function?

2159

Explain what are the different methods of loading dimension tables?

953

What are the main differences you have observed between 7.x and 8.x version of datastage?

1089

Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

2860

Explain what is the difference between a primary and secondary actor in use case modeling?

1065

if ur report having report filter save the report.open u r report in cc the report filter doesnt work means it does n't any values what we do for this situation?where we rectify this?please please ans me......

1919

Explain the code page compatibility?

1066

Can microstrategy intelligence server scale easily and cost effectively based on my growing needs?

1054

Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

2169

Name the different lookup cache(s)?

1234

how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?

2263

Explain what are fact, dimension, and measure?

992

how to change the execute of macro

2315

Explain what are the steps to be taken to schedule the report?

1108

What is the difference in the way microstrategy handles custom group and consolidations?

995

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