Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Data Warehouse General Interview Questions
Questions Answers Views Company eMail

What is the difference between aggregate table and materialized view?

1100

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

1387

Where the data cube technology is used?

959

What are data modeling and data mining?

1085

What is surrogate key? Explain with examples.

1158

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

1061

What is a real-time data warehouse?

998

Can any one explain about core dimension, balanced dimension, and dirty dimension?

1055

How do you define data block size?

1047

What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?

1071

What are the possible data marts in retail sales?

998

What is informatica architecture?

1065

What is a real-time data warehouse? How is it different from near to real-time data warehouse?

959

explain about balanced dimension,

982

Briefly state different between data ware house & data mart?

1049


Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What is defined as partial backup?

1075


What are the different models used in cluster analysis?

961


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

975


What are the differences between datamart vs. Reporting cube?

1097


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

1005


What are data validation strategies for data mart validation after loading process?

1016


Can you state some of the innovations throughout history?

981


How do you define data block size?

1047


explain about dirty dimension?

1176


What are the various tools? Explain name a few?

959


After we create a scd table, can we use that particular dimension as a dimension table for star schema?

996


What is an error log table in informatica occurs and how to maintain it in mapping?

965


How do you create surrogate key using ab initio?

996


Which technology should be used for interactive data querying across multiple dimensions for a decision making for a dw?

1066


Explain hybrid slowly changing dimension?

1006