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 8733

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

TCS,

7 10404

differences between service based and product based?

Satyam,

2060

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

Patni,

2 7831

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 7373

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

Patni,

1 3728

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

Zensar,

2 11560

why we use materialized view over view?

Zensar,

1 5405

can session assigned multiple mappings or not?

Zensar,

2 8262

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

Satyam,

1 5350

what is the default character set in teradata,,?

IBM, TCS,

2 11398

What is SQL Assistence?please eample

IBM,

4 8501

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

1 4497

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

Cognizant,

1 3163

in performance wise union is past,union all is past

2 5543

Un-Answered Questions { Data Warehouse }

In sas, what are the areas that you are most interested in? : sas-grid-administration

1135

can we perform checkin and checkout through sandbox?

1230

What is mapplet in informatica?

1131

ware house management system is used?

1059

Differentiate between Load Manager and DTM?

2217

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

2011

Are you involved in writing the inferential analysis plan? Tables specfications?

2270

Why do we use exception activity in Datastage?

1374

what the mean of version error in crystal?

2452

Name the different types of Lookups in Datastage?

1313

Can we access the compute node of Redshift directly ?

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1963

What is a cursor? Within a cursor, how would you update fields on the row just fetched?

1237

What does sleep function does in fast load?

1213

explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

2563

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