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 17745

waht is the advantage of infoset query

iGate,

2363

what is the diffrence between psa and idoc

iGate,

2275

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

ASD Lab, IBM,

1 6404

Compare and contrast aggregates & indexes

IBM, TCS,

3777

Compare aggregates and data marts

TCS,

2768

what role views play in dimensional modeling?

TCS, Zensar,

1 5922

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

HSBC,

3 9272

what are the all possible features supported modify stage?

2141

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?

2028

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 7915

what is hybrid schema

TCS,

4 16641

How many ways we test the universe & Report?

2 6109

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

TCS,

1 9450

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

Explain what are the various file formats involved in reportnet?

944

What is the working process for application.cfm?

1047

What is batch processing?

1035

Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?

1022

How to get the first 100 rows from the flat file into the target?

1210

The same tier?

1062

Explain the difference between oltp and olap?

1127

What is data analysis?

966

What are Non-additive facts?

1169

Can a dimension table contain numeric values?

1061

What is the main difference between schema in rdbms and schemas in datawarehouse?

1093

What is bi?

1099

Do you view contain data?

943

What is a junk dimension? What is the difference between junk dimension and degenerated dimension?

933

What is meant by metadata in context of a data warehouse and how it is important?

1205

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