Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Data Warehouse General Interview Questions
Questions Answers Views Company eMail

Difference between slicing and dicing with example?

2 14633

waht is the advantage of infoset query

iGate,

1423

what is the diffrence between psa and idoc

iGate,

1312

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

ASD Lab, IBM,

1 4935

Compare and contrast aggregates & indexes

IBM, TCS,

2890

Compare aggregates and data marts

TCS,

1774

what role views play in dimensional modeling?

TCS, Zensar,

1 4161

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

HSBC,

3 6390

what are the all possible features supported modify stage?

1189

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,

1527

in general which algorithms for used?

1101

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 5668

what is hybrid schema

TCS,

4 12733

How many ways we test the universe & Report?

2 4126

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

TCS,

1 7196


Post New Data Warehouse General Questions






Un-Answered Questions { Data Warehouse General }

what is user variable in affinium campaign? and some real time examples.

3296


What are diagrams?

152


"A dimension table is wide but the fact table is deep," explain the statement in your own words.

195


How can you set the client management?

137


What is defined as partial backup?

159






Explain some of modeling tools available in the market?

146


Explain what is ods (operation data source)?

128


Explain difference between data ware house & data mart?

137


What we will do with the universe for faster process?

166


Explain what are the modules in power mart?

137


Explain what is the difference between stop and abort?

135


What is meant by metadata in context of a data warehouse?

134


What are data modeling and data mining?

142


Why is dimensional normalization not required?

145


Why denormalization is promoted in universe designing?

141