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

Explain the term 'foreign key' related to relational database management system?

1058

What are the string manipulation operators and functions associated with teradata?

1108

Explain the term 'tables' related to relational database management system?

1070

Explain the term 'row' related to relational database management system?

971

What is teradata? Also, list out some of the primary characteristics of teradata.

1073

What are the available primary index types?

1235

List out some of the primary characteristics of teradata.

1030

Describe the set operators in teradata.

1019

What are the available join types in teradata?

1086

What are the various kinds of the hash file?

1161

If you want to use a same piece of code in different jobs, how will you achieve this?

1289

What are datastage sequences?

1133

How do you start developing a datastage project?

1125

Where do you see different stages in the designer?

1110

What is the difference between passive stage and active stage?

1555

Un-Answered Questions { Data Warehouse }

What are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?

1110

What is staging variable?

1110

How do we convert from Numeric to be Words?

3038

what is the role of transformer?

How do you use the do loop if you don’t know how many times you should execute the do loop?

1279

Give the benefits of data integration suite?

935

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1917

How do y read Sequential file from job control?

15988

How to apply securities for reports in cognos connection?

2548

Is there any difference in testing database and data ware housing?

2772

Describe implicit attribute?

1026

(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.

1547

What information is shared by the application across microstrategy web nodes?

1062

Differentiate between source qualifier and filter transformation?

1588

what is the difference between infile and input? : Sas-administrator

1157

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