Data Warehouse General Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Data Warehouse General Interview Questions

Questions Answers Views Company eMail

Difference between slicing and dicing with example?

2 17841

waht is the advantage of infoset query

iGate,

2408

what is the diffrence between psa and idoc

iGate,

2312

Can we have more than one time dimensions in a Schema(Star or Snowflake)

ASD Lab, IBM,

1 6464

Compare and contrast aggregates & indexes

IBM, TCS,

3820

Compare aggregates and data marts

TCS,

2812

what role views play in dimensional modeling?

TCS, Zensar,

1 5990

how to calculate sum(sal) with out using aggregator satge

HSBC,

3 9420

what are the all possible features supported modify stage?

2224

what is the synchonus? wht is the diff between synchronous and asynchronous what is the diff between v1 and v2 v3 delta modes in sap ecc

IBM,

2541

in general which algorithms for used?

2073

Hi Guys, I have been to L& T last week ..Please find the questions mentioned below 1)Slowly changing dimension types 2)DML statement 3)DDL statement 4)write a syntax to create database 5) differences between count(*) and count(column) 6) differences between union and union all 7) what is decode 8) what is NVL 9) Arrange the values in ascending order 10,5,20,15,null 10)Primary and surrogate key 11)what is group by clause does? 12)what is difference between truncate and delete 13)what is difference between OLAP and OLTP ? 14)Architecture of Datawarehouse 15)how do you test the data validation from source as (flat file and xml) to staging tables. 16)what is shedule and time bound the mentioned above question asked in two rounds.all the best

L&T,

2 8007

what is hybrid schema

TCS,

4 16780

How many ways we test the universe & Report?

2 6200

In datastage can ve find the job based on source table name ??

TCS,

1 9533

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

Explain functional dependency?

1137

Is there any default username & pwd for bo designer & supervisor?

1083

Explain what are non-additive facts in detail?

1086

What are the various methods of getting incremental records or delta records from the source systems?

995

Explain what is the difference between power center & power mart?

1047

Where we use surrogate key explain with example?

1206

Explain dimensional modelling?

1029

How we are using this function?

1186

What are the reasons to use a chameleon method in data warehousing?

1101

Can you describe me a problem you faced when you were trying to load data from R3 system and another system outside sap systems?

2176

What is drill-through?

1045

What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?

1182

Explain the difference between filter and conditin?

1014

Explain what type of indexing mechanism do we need to use for a typical datawarehouse?

1075

What are the different methods of loading dimension tables?

1042

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