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

2,can we insert duplicate data with dynamic look up cache,if yes than why and if no why?

TCS,

2 8613

3,if our source containing 1 terabyte data so while loading data into target what are the thing we keep in mind?

TCS,

7 10181

differences between service based and product based?

Satyam,

2014

What is the BO project Architecture? Explain in detail? Thanks in advance for ur answers?

Patni,

2 7680

my source having the records like ram 3 sam 5 tom 8 and i want to load into target like ram record 3 times,sam record 5 times, tom record 8 times

Satyam,

3 7239

What is the architecture of ur project? can u explain it? PLz

Patni,

1 3642

Can we insert ,update ,delete in target tables with one update strategy tran.?

Zensar,

2 11442

why we use materialized view over view?

Zensar,

1 5303

can session assigned multiple mappings or not?

Zensar,

2 8147

we have to use order by,where,having we to implement sql query

Satyam,

1 5267

what is the default character set in teradata,,?

IBM, TCS,

2 11283

What is SQL Assistence?please eample

IBM,

4 8334

Difference between Microstrategy and Hyperion if any one Knows kindly updated me my dear Friends

1 4376

in aggregator transformation we want to get middle record how to implement, source containg empno,name sal,deptno,address

Cognizant,

1 3099

in performance wise union is past,union all is past

2 5439

Un-Answered Questions { Data Warehouse }

what are the component of range? : Sas-bi

1097

How does microstrategy object manager integrate with the microstrategy product suite security model?

938

What is a pdv and what are its functions?

1152

What are multi-group transformations?

1096

What are the six data process products of ab initio (architecture of ab initio)?

1116

how would u estimate the size of Aggregator transform data and index cache?

1961

what is sas enterprise intelligence architecture? : Sas-bi

977

What are the basic requirements to join two sources in a source qualifier transformation using default join?

1128

explain about dirty dimension?

1173

what actually happens when bulk load mode starts?

What are the advantages of shortcuts?

968

What are the different design perspectives used in teradata?

982

What are the available primary index types in teradata.

1032

What is data warehosuing hierarchy?

1172

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?

1068

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