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 16624

WHAT DOES SQL TAB CONTAIN?

Polaris,

1 5734

HOW TO SEND THE PARTICULAR REPORT DIVISION AND PARTICULAR USER?

Polaris,

2 6499

WHAT ARE THE VARIOUS PRODUCTS IN BO?

Polaris,

2 6303

What is conformed dimension?

Polaris,

6 11148

WHAT IS FACT LESS FACT TABLE?

DBS, Polaris,

6 17271

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

Accenture,

2 8314

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

3022

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

1 4496

HOW MANY TABLES ARE EXISTED IN WEBI REPORT?

Polaris,

3 9349

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

IBM, TCS,

9 47702

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

NSE,

1 8782

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

Rolta, TCS,

2 7542

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

L&T,

2 13075

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

Mind Tree,

2 5453

Un-Answered Questions { Data Warehouse }

How to update or delete the rows in a target, which do not have key fields?

1226

What is meant by a Clique?

1118

Differentiate between data file and descriptor file?

1107

Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?

1069

What is by-group processing?

1059

what is informatica metadata?

1092

Can you explain the co>operating system’s processing model?

1156

Explain what is the metadata extension?

1102

Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

2902

What is a core dimension?

1120

Have you have ever worked in unix environment and why it is useful in datastage?

1194

How the Bursting happens in same report and how to Print the bursting Report?

1922

Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

1729

what is proc Index? and what is proc document?

2776

What is active and passive stage?

1471

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