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 16918

Which kind of index is preferred in DWH?

3 12206

what is fact table?

9 13654

what is dimension table?

17 32850

what is metadata?

Satyam,

8 12679

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 11547

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 11338

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 26876

name the air commands in ab initio?

IBM, Syntel,

2 61185

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 13914

Do we really work with ACTUALDATA in development phase.

4 8513

How do we extract data from client machine?

1 8752

How can we RUN a graph in UNIX?

3 24612

what does .. meant in sas macros

D&B,

3 10091

Un-Answered Questions { Data Warehouse }

How many types of sorting methods are available in datastage?

1083

What a static and local variable?

1093

what is business intelligence? : Sas-bi

1078

How many types of transformations supported by sorted input?

1237

What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.

4599

What is the difference between the standard and metrics folder?

984

What is pre-emptive and non-pre-emptive?

995

What are the new features included in the new version of SAS Programming Language?

1222

What is catalog and types of catalogs in cagonos and which is better?

1028

What is data analytics in simple terms?

1205

is data integration and etl programming is same? : Sas-di

1090

In document how to create metrics?

1006

Explain what are non-additive facts?

1045

hi my name is siraj i want to know cognos queriy language

2286

After applying date prompt and when we run the report we fet from date and todate prompts..so when we enter todate

2049

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