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 cognos reporting tool?

1089

Can you define a query subject?

1018

Can you define cognos impromptu?

1029

Can you explain cognos planning?

1092

Can you define cognos powerplay?

1093

Can you explain a cognos controller?

1020

What is the difference between orabulk and bcp stages?

1025

What is the difference between validated and compiled in the datastage?

1291

What is the differentiate between data file and descriptor file?

1362

What is the difference between odbc and drs stage?

1092

Can you explain repository tables in datastage?

1407

What is the roundrobin collector?

1098

What is difference between join, merge and lookup stage?

1095

What is quality stage?

987

Can you explain engine tier in information server?

1135

Un-Answered Questions { Data Warehouse }

Explain attribute?

974

what type of graphs we will create(for 2+years candidates)?

2309

2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.

2212

Have you created hierarchy in obiee. If so where and how?

887

What are the different types of parallelism in ab initio?

1221

What are the main features of Oracle 8i with context to datawarehouse?

2112

Explain the types of join supports by teradata?

994

how u will determine the performence tune will occur either in report or system

2135

How do we load data into Redshift?

Is union transormation is active transformation?

974

please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.

2005

Explain what is the extension of file to save template?

977

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

2047

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

2065

Give the advantages of cognos?

1034

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