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 11569

What are the types of error logs available in Informatica?

1 6305

Different types of Power center errors?

Cinterco, IBM,

1 8060

Define Update Override?

1 4755

Define error Threshold?

1 5044

Examples of Fatal & Non-Fatal error?

Cap Gemini,

2 22515

Difference Between ETL & ELT?

TCS,

1 7737

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

3 7810

Define Incremental Aggregation?

2 6902

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 9041

Can we use parameters of parameter file in presession command

Wipro,

1 7105

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

2 7106

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 4136

what is subqueary and what is temporary tables?

BirlaSoft,

3 7416

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 6517

Un-Answered Questions { Data Warehouse }

What will be the output when a file with 0 records is connected as input to a reformat and an output file? Note that in reformat we have assigned hardcoded values to output columns.

1004

In development project what is the process to follow for an etl developer from day1

1731

Which development components of informatica have the highest usage?

1068

I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

1082

Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?

2140

wat are deployement groups in informatica, how it will be used for developers

1733

what is the function of catx syntax? : Sas-administrator

1116

How do you verify a complicated sql?

1075

Repository user profiles

1774

Mention what is a partition and what are the different types of partition components in abinitio?

1196

you are required to disable webusers to use only one i-server. How would you do that?

905

What are types of partition primary index (ppi) in teradata?

1065

whats the logic to load the lower level of granularity of data to fact table.

2285

1097

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1294

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