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

whether Sequence generater T/r uses Caches? then what type of Cache it is

Accenture,

7 17181

Which kind of index is preferred in DWH?

3 12322

what is fact table?

9 13961

what is dimension table?

17 33451

what is metadata?

Satyam,

8 13019

In a shcool there are 1000 students. After completion of every test in 6 subjects , each subject teacher submit the marks of every student at different times and loaded in the database commonly. How will you seperate the top two subject marks for each each studet using SAS?

6 9283

How can we publish package to QA environment not cognos connection?(if we have two URL one cognos connection and qa environment how can we publish package to qa?)Please anybody give me the answer.

TCS,

4 11709

For example I developed some reports on employee package now I have to develop same reports to another package.How can I change reports to another package?

TCS,

5 11546

Report studio has two SQL tabs one native SQL and another one cognos SQL which one is get more preference? which one we need to consider?

Blue Cross Blue Shield Association, TCS,

7 27157

name the air commands in ab initio?

IBM, Syntel,

2 61469

There is a field containing a date. It needs to be displayed in the format "ddmonyy" if it's before 1975, "dd mon ccyy" if it's after 1985, and as 'Disco Years' if it's between 1975 and 1985. How would you accomplish this in data step code? Using only PROC FORMAT

D&B,

8 14207

Do we really work with ACTUALDATA in development phase.

4 8669

How do we extract data from client machine?

1 8844

How can we RUN a graph in UNIX?

3 24763

what does .. meant in sas macros

D&B,

3 10249

Un-Answered Questions { Data Warehouse }

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

2264

Hi friends, what are the new features in abinito3.0?

2860

What is node? How many nodes and amps used in your previous project?

1173

Explain about a tricky situation for which you found a very simple solution?

1077

What is rollup component?

1333

How to create the source and target database connections in server manager?

1144

How do you remove duplicate records in informatica? And how many ways are there to do it?

1233

what are the data modeling tools you have used?(polaris)

2057

Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2493

hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..

1962

What r the names of the reports that you prepared?

1029

EXL informatica Questions

1461

How would you format some text using css to be verdana and bold?

1150

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2421

what are the dimensions that you have in your current project?list them?

2093

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