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 to return multiple columes through through un-connect lookup?

DELL,

1 6983

explain one complex mapping with logic? sales project?

Accenture, JPMorgan Chase,

6668

Performance tuning in UNIX for informatica mappings?

CGI, CTC,

2568

How to Migrate the UNIX SCRIPTS from SIT TO PROD?

1 3049

How to do the error handling of if ur source is flatfiles?

1968

In ur current projectu have done any performance tuning of mappings?

1 4623

In which scenario did you used pushdown optimization?

1 3315

In which scenario did u used Mapping variable?

Cognizant,

1 2699

In Which scenario did u used Incremental loading?

2 6187

Did u used latest transformations of 8.6.0? for what?

1882

When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?

1 7598

what is semi-additive fact?where did u used?

2 5399

I am using mapping variable, when i am running a session,before it has 10000 records, after completion of session what about value of mapping variable?

1 3946

In dimension and fact table? which one holds big data?

2 6457

my table contain duplicate Records i wanna load uniq records to my table . i have to pass the uniq records through filter t/r how?

ACS,

3 7791

Un-Answered Questions { Data Warehouse }

What is a joiner transformation?

995

What do you mean by teradata intellicloud?

1038

What is sorter transformation?

1045

WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?

6898

Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

2228

what is pmrep command?

2437

What is a shortcut and copy in Informatica and how two are different with each other?

1196

Can you explain how could anyone drop the index before loading the data in target in datastage?

1504

--------------Explain Table of contents?

2024

What are the primary keys and foreign keys?

1142

What do the mod and int function do? : Sas programming

1227

Explain pushdown optimization $pushdownconfig parameter - informatica

1137

What do you mean by the term data warehousing? Is it different from data mining?

1219

how do you use tm1 cubes in framework manager?

explain about various caches available in data integrator? : Sas-di

1050

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