GeekInterview.com
  I am new, Sign me up!
 

Data Warehousing Basics


Data Warehousing Basics

Questions: 113
Comments: 596
 Data Warehousing Basics Tags
 Showing Questions 1-10 of 113 Questions
[1] 2 3 4 5 6 7 8 9 10 Next >>
 Sponsored Links

 
 Data Warehousing Basics
Sorting Options :  

What is the use of bridge table. Can give a simple example? 
Latest Answer: Hi all... This is my view on bridge tables:Bridge table in simple can be called as reference tables. As the name indicates, this table can be used to link two tables with 1 reference id. It can be explained in detailed with the below example.Say, 2 ...

How does replication takes place between two sites? 
View Question | Asked by : elothrop

Latest Answer: System Requirement Gathering Selecting Tool. Data Modeling and design ETL Process OLAP Cube Design Front End Development Performance Tuning User Acceptance Test ( UAT ) Rolling out to Production Production Maintenance ...
Read Answers (7) | Asked by : josri

Latest Answer: Data from different sources (like flatfiles, CSV, oracle, db2,teradata, mainfraes etc.) are extracted and transformed in to a single specific pattern (unique structure) and is know as integration of data.The ETL tools like datastage, informatica and pentaho ...
Read Answers (3) | Asked by : msmart

Latest Answer: The transformation of keys which are supposed to be used as primary key into generic key by the system is called as key restructuring. The problem is something like this, let us a say there was an existing system for keeping record of each house in ...
Read Answers (1) | Asked by : msmart

Outline the procedure for the feasbility study of building datawarehouse for a company. 

Please provide me deep info on Normalizer ! 
Latest Answer: It is GCID which means Generic Column ID. When a Normalizer transformation is used to read Cobol sources, the Informatica Designer identifies the 'OCCURS' and 'REDEFINES' statements and generates 2 columnsGenerated Key one port for each REDEFINES ...

What is the difference between ODS and Staging? 
Latest Answer: ODS keeps the transactional data from where direct reporting is possible. The data in ODS can be partly denormalized.Staging area is the exact replica of the transactional database which acts as a source for datawarehouse processing. ...
Read Answers (5) | Asked by : raja_vnb

For a Customer or Product Dimension with 500,000 rows changing daily an ETL solution is the only sensible way forward. But surely you shouldn't ETL every single Dimension table - especially if there's 
Latest Answer: If you are designing a Data Warehouse how can you rely on manual process? better way is to use ETL wherever required or else just extract and load.But you should refresh all your dimensions regularly and not manually.better to check for the changed data ...
Read Answers (1) | Asked by : jryan999

Bill Inmon vs Ralph Kimball In the data warehousing field, we often hear about discussions on where a person / organization's philosophy falls into Bill Inmon's camp or into Ralph Kimball's 
Latest Answer: Bill inmon's approach:--------------------------- Approach is "TOP DOWN approach".  ;means Emphasize the data warehouse.   Starts with designing an enterprise model for datawarehouse.  Multi tier architecture - comprise ...
Read Answers (2) | Asked by : Pranay

View page [1] 2 3 4 5 6 7 8 9 10 Next >>

Ask A Question
Go Top
 Sponsored Links

 
Sponsored Links

 
Ask Question
You must login to Ask Question or Register your free account

Category:

 
Question Title:


Question in Detail:

Add this to my Subscribed Questions (?)
Send me email when new answer is posted (?)

 
Expert Members
Subscribe
Get Latest Updates Via RSS Reader or by Email
 Forum Discussion Subscribe to Forum Discussions Via E-Mail Latest Forum Discussions Subscribers
 Knowledge Base Subscribe to Knowledge Base Series Via E-Mail Knowledge Base Subscribers
 Learning Series Subscribe to GeekInterview Learning Series Via EMail Learning Series Subscribers
 Freelance Jobs Subscribe to GeekInterview Freelance Jobs Via EMail Latest Freelance Jobs Subscribers
 GeekInterview Blog Subscribe to GeekInterview Blog Via EMail GeekInterview Blog Subscribers
 Testing Interview Questions Subscribe to Testing Interview Questions Via EMail Testing Interview Questions Subscribers
 Oracle Interview Questions Subscribe to Oracle Interview Questions Via EMail Oracle Interview Questions Subscribers
 Java Interview Questions Subscribe to Java Interview Questions Via EMail Java Interview Questions Subscribers
 Latest Placement Papers Subscribe to Latest Placement Papers Placement Papers Subscribers
 Free Training Subscribe to Free Training Via EMail Free Training Subscribers
 Learn AJAX Subscribe to AJAXwith.com Via EMail AJAXwith Subscribers
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape