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

How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...

Cap Gemini,

1 16518

WHAT DOES SQL TAB CONTAIN?

Polaris,

1 5631

HOW TO SEND THE PARTICULAR REPORT DIVISION AND PARTICULAR USER?

Polaris,

2 6378

WHAT ARE THE VARIOUS PRODUCTS IN BO?

Polaris,

2 6207

What is conformed dimension?

Polaris,

6 10905

WHAT IS FACT LESS FACT TABLE?

DBS, Polaris,

6 17031

why only we use SAS? their r many programmin language like SPSS, Oracle... Why SAS?

Accenture,

2 8206

REGULAR CLASSES for Hyperion Financial Management+ODI+HFR+FDQM is Starting From Sunday, 23th Oct, 7:00 AM IST.

2962

REGULAR CLASSES for OBIEE Reporting(RPD, Answer, BI Publisher) is Starting From Tuesday, 25th Oct, 7:00 AM IST

1 4417

HOW MANY TABLES ARE EXISTED IN WEBI REPORT?

Polaris,

3 9194

How can you find the 2nd Highest salary in a file department wise in abinitio?

IBM, TCS,

9 47362

What is the difference between Report Bursting and Report scheduling?Explain both of them in detail?

NSE,

1 8684

When we r going for Short_cut join & It's Resolution??? Plz provide one scenario??

Rolta, TCS,

2 7434

How to enter a log in auditing table whenever a job get finished?

L&T,

2 12959

1.When did 8.1 parallel came into existence? 2.What is the difference between 7.5 and 8.1?

Mind Tree,

2 5361

Un-Answered Questions { Data Warehouse }

what is hints in cognos and where we use it.

2455

r u done any partitions in ur project?

1827

Explain the datastage parallel extender (px) or enterprise edition (ee)?

1225

How do you determine the number of sessions?

1062

How many tables can you join in v2r5?

1072

In informatica workflow manager, how many repositories can be created?

1361

What is edw?

1196

How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?

1537

What is etl process?

936

What if the source is a flat-file?

1110

Can reports be executed in off-peak periods?

997

What needs to be done when the database is shutdown?

1025

how to test reports in cognos?

1028

What is the different type of jobs in datastage?

974

What is zero-foot print?

1019

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