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 16520

WHAT DOES SQL TAB CONTAIN?

Polaris,

1 5637

HOW TO SEND THE PARTICULAR REPORT DIVISION AND PARTICULAR USER?

Polaris,

2 6383

WHAT ARE THE VARIOUS PRODUCTS IN BO?

Polaris,

2 6210

What is conformed dimension?

Polaris,

6 10927

WHAT IS FACT LESS FACT TABLE?

DBS, Polaris,

6 17042

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

Accenture,

2 8212

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

2968

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

1 4419

HOW MANY TABLES ARE EXISTED IN WEBI REPORT?

Polaris,

3 9204

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

IBM, TCS,

9 47384

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

NSE,

1 8686

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

Rolta, TCS,

2 7446

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

L&T,

2 12961

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

Mind Tree,

2 5364

Un-Answered Questions { Data Warehouse }

Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?

1243

What are different types of metrics in microstrategy?

964

Describe the elements you would review to ensure multiple scheduled batch jobs do not collide with each other?

1133

Explain how to schedule the report in b.o?

1052

What is the function that transfers a string into a decimal?

1159

Mention the validation tools used in SAS?

1182

After the generation of a report to whom we have to deploy or what we do after the completion of a report?

914

What is the use of report studio?

1032

What is difference between server jobs & parallel jobs?

1039

Mention some types of transformation?

1048

What is a connected transformation?

1125

What are different deliverables according to phases?

3407

Explain the different types of views used in cognos.

949

How do you improve the performance of a graph?

1149

What will calendar procedure do?

1079

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