-
How to Create new user in Datastage 7.5
I want to create new user in datastage 7.5 I dont know how to do it?
-
Aggregator Stage Hash Partition
How will the performance improve by using Hash partition in Aggregator stage?
-
Dataset Parallel Jobs Performance
Will the performance improve by using dataset in parallel jobs? How?
-
Bridge Table
What is the use of bridge table. Can give a simple example?
-
Extract / Transform Process
Describe the stages of extract / transform process, including what should happen at each stage and in what order?
-
-
-
Explain Bill Inmon's versus Ralph Kimball's Approach to Data Warehousing.
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 camp. We describe below the difference between the two.Bill Inmon's paradigm: Data warehouse is one part of the overall business intelligence system. An enterprise has one data warehouse, and data marts source their...
-
-
-
-
-
What are Stage Variables, Derivations and Constants?
Stage Variable - An intermediate processing variable that retains value during read and doesnt pass the value into target column. Derivation - Expression that specifies value to be passed on to the target column. Constant - Conditions that are either true or false that specifies flow of data with a link.
-
What is a Star Schema
Answer posted by Chintan on 2005-05-22 18:34:55: A relational database schema organized around a central table (fact table) joined to a few smaller tables (dimension tables) using foreign key references. The fact table contains raw numeric items that represent relevant business facts (price, discount values, number of units sold, dollar value, etc.)