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 17733

waht is the advantage of infoset query

iGate,

2363

what is the diffrence between psa and idoc

iGate,

2272

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

ASD Lab, IBM,

1 6402

Compare and contrast aggregates & indexes

IBM, TCS,

3776

Compare aggregates and data marts

TCS,

2765

what role views play in dimensional modeling?

TCS, Zensar,

1 5918

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

HSBC,

3 9267

what are the all possible features supported modify stage?

2137

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,

2500

in general which algorithms for used?

2026

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 7911

what is hybrid schema

TCS,

4 16639

How many ways we test the universe & Report?

2 6106

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

TCS,

1 9447

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

Is union transormation is active transformation?

975

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

2117

Explain the different types of data warehousing?

991

What is the limit to the number of sources and targets you can have in a mapping?

1108

Explain what is a three tier data warehouse?

975

How many types of facts and what are they?

1018

What are the advantages and disadvantages of reporting directly against the database?

982

Difference between cold fusion 5 and cold fusion mx 6?

995

How do you setup Lo-cockpit?

3164

How to improve session performance in aggregator transformation?

984

Explain what is the limit to the number of sources and targets you can have in a mapping?

1005

What is ods (operation data source)?

997

Explain what is a view as it relates to system modeling?

987

hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit

2050

What are the differences between star and snowflake schema?

1106

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