What is the use of bridge table. Can give a simple example?
Latest Answer: An example of a Bridge table would be relationship table between student_master and courses_master. A Student may participate in multiple courses and obviously in a course there will be multiple students. In this scenario to maintain relationships between ...
How does replication takes place between two sites?
Latest Answer: 1. Requirement gathering (involved in face to face discussion with the
clients regarding what is their requirement)
2. Data modeling (where we fix the schema design for warehouse)
3. Data profiling
4. Data cleansing
5. ETL ( 1. Extracting the ...
Latest Answer: Data Integration is a process in which data from disparate, homogeneous or heterogeneous systems is cleansed, aggregated, consolidated, de-normalized and loaded into a single database or data warehouse after applying business rules. ...
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
