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 commands to make a new table, change a table and remove a table in teradata?

1143

List the logical and conditional operators that are used with teradata along with their meanings?

1011

What is the basic syntax for teradata select statement?

1059

What is the purpose of using case expression in teradata?

1033

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

996

Describe the between keyword in teradata?

1050

What are the different table types that are supported by teradata?

1015

What are the frequently used data types in teradata?

1096

What is the purpose of joins in teradata?

1204

What is teradata?

1174

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

1055

Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.

1055

What is the purpose of joins in teradata and what are the available join types?

1101

Discuss the advantages of using partitioned primary index in a query?

969

Define views in teradata with general syntax.

1047

Un-Answered Questions { Data Warehouse }

Difference between inner join and outer join?

1046

Differences between version 7.x and 8.x.

1912

what is hierarchy flattening? : Sas-di

1098

Why need staging area database for dwh?

1090

why do u need the IOS upgradation in a FC switch

2293

What are the supported languages for microstrategy intelligence server?

1039

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

2199

what is the use of proc sql? : Sas programming

1150

dimension object created in oracle can be imported in designer?how?

3001

Write various indexes used in cognos?

981

Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.

1097

If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1509

What is the function of cognos dispatcher?

1233

Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com

2413

What is time series wizard? When and how do you use it?

1656

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