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?
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 ...
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 ...
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 ...
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. ...
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 ...
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 ...
View page [1] 2 3 4 5 6 7 8 9 10 Next >>
Go Top
