1. Categories >> Software >> Data Warehouse
  2. Suggest New Category


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 15594

WHAT DOES SQL TAB CONTAIN?

Polaris,

1 4970

HOW TO SEND THE PARTICULAR REPORT DIVISION AND PARTICULAR USER?

Polaris,

2 5445

WHAT ARE THE VARIOUS PRODUCTS IN BO?

Polaris,

2 5322

What is conformed dimension?

Polaris,

6 8955

WHAT IS FACT LESS FACT TABLE?

DBS, Polaris,

6 14877

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

Accenture,

2 6778

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

 2493

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

 1 3810

HOW MANY TABLES ARE EXISTED IN WEBI REPORT?

Polaris,

3 7916

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

IBM, TCS,

9 42521

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

NSE,

1 7527

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

Rolta, TCS,

2 6513

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

L&T,

2 11581

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

Mind Tree,

2 4490

Un-Answered Questions { Data Warehouse }

What are the types of SCD?

632

What are the types of lookup transformation?

631

Explain what is the difference between stop and abort?

546

If informatica has its scheduler why using third party scheduler?

778

what is an use case?

624




Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?

521

For which purpose Redshift is used for ?

5

How you know when to use a static cache and dynamic cache in lookup transformation?

1341

Target increases every day even though no new record was inserted

1109

Explain why fact table is in normal form?

539

What are the different options available for update strategy?

580

How many dimensions are there in informatica?

630

How will you port changes for dashboards,reports,rpd from development to production?

536

describe how to adjust the performance of data integrator? : Sas-di

567

Where the data cube technology is used?

549

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