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 16917

Which kind of index is preferred in DWH?

3 12204

what is fact table?

9 13651

what is dimension table?

17 32842

what is metadata?

Satyam,

8 12678

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 9076

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 11542

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 11328

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 26874

name the air commands in ab initio?

IBM, Syntel,

2 61180

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 13913

Do we really work with ACTUALDATA in development phase.

4 8513

How do we extract data from client machine?

1 8751

How can we RUN a graph in UNIX?

3 24605

what does .. meant in sas macros

D&B,

3 10089

Un-Answered Questions { Data Warehouse }

What are the steps involved in creating dimensional modeling process?

1030

If you have a dataset that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variables?

1178

Name the five phases that come under MultiLoad Utility.

998

What is collect statistics?

1016

what is sysdba and sysdbc ? which has high priority ?

3844

How do u convert the columns to rows in datastage?

1210

Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?

974

In a star schema, are foreign key constraints between facts and dimensions neccessary?

990

How can users design dashboards quickly and without programming experience or training?

968

Why is it required to maintain a parent-child relationship among the various attributes? What are the various types of relationships depending on the number of participants?

1024

What is m_dump?

1243

What is the role of sas grid administrator? : sas-grid-administration

1300

What is the maximum length of the macro variable? : sas-macro

1110

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

1090

Can a record be inserted and updated in database using microstartegy?

945

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