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

Difference between STOP & ABORT in Informatica.

Accenture, Wells Fargo,

3 11538

What are the types of error logs available in Informatica?

1 6287

Different types of Power center errors?

Cinterco, IBM,

1 8043

Define Update Override?

1 4740

Define error Threshold?

1 5027

Examples of Fatal & Non-Fatal error?

Cap Gemini,

2 22487

Difference Between ETL & ELT?

TCS,

1 7715

My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggregator T/R?

3 7781

Define Incremental Aggregation?

2 6881

There are 4 source files which contains same metadata create target that should display the file name along with record please send answer with mapping

Wipro,

3 9016

Can we use parameters of parameter file in presession command

Wipro,

1 7088

metric filter and report have a another filter which is highest priority ? why?

2 7083

From Business Objects Web-I reports, we can link to other BO reports using Opendoc functinality. How do we link to reports in other reporting tool or how to give a link any website?

1 4116

what is subqueary and what is temporary tables?

BirlaSoft,

3 7386

Hi frns, In the report level i have dragged objects in the query panel. If i check the sql query it is displaying 2 separate queries. What will be the possibilities for this?

Accenture,

2 6501

Un-Answered Questions { Data Warehouse }

What is the difference between condition & filter?

1460

Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?

975

List out some key concept of SAS

1125

What is the difference between business requirement document and use case document.

1008

Explain lookup transformation source types in informatica

1098

Which warehouse using in your datawarehouse

2185

is it possible to index the data in cache of lkp transformation ?

2029

Explain dynamic target flat file name generation in informatica

1055

explain one complex mapping with logic? sales project?

6669

Explain what is real time data-warehousing?

1104

Explain clustering?

978

What is the difference between absolute filtering and standard filtering in microstrategy?

979

What is the difference between union and union all in teradata?

1128

Explain what is sort component in abinitio?

1104

How are models actually derived?

2005

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