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

  1. Categories >> Software >> Data Warehouse >> Data Warehouse General
  2. Suggest New Category
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

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