|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 Related Questions Surrogate Key is a Primary Key for a Dimension table. Most importance of using it is it is independent of underlying database. i.e Surrogate Key is not affected by the changes going on with a database. Latest Answer : surrogate key is nothing but a primary key,it gives a serial no. to all records.surrogate key is act's as a major role in type 2 scenario.if u have any updates to be applied on a database it will be directely effected on datawarehouse part(using surrogate ... Fact table - Table with Collection of Foreign Keys corresponding to the Primary Keys in Dimensional table. Consists of fields with numeric values. Dimension table - Table with Unique Primary Key. Load Latest Answer : __________________ _______________ ________________|_________________| |______________ ... Container is a collection of stages used for the purpose of Reusability. There are 2 types of Containers. a) Local Container: Job Specific b) Shared Container: Used in any job within a project. Latest Answer : Container is a collection of stages used for the purpose of Reusability. There are 2 types of Containers. a) Local Container: Job Specific b) Shared Container: Used in any job within a project. · There are two types of shared container:· 1.Server shared ... Typically a Reject-link is defined and the rejected data is loaded back into data warehouse. So Reject link has to be defined every Output link you wish to collect rejected data. Rejected data is typically Latest Answer : we can handle rejected data by collecting them seperately in sequential file...... ... The above might rise another question: Why do we have to load the dimensional tables first, then fact tables: As we load the dimensional tables the keys (primary) are generated and these keys (primary) are Foreign keys in Fact tables. Latest Answer : 1. Hashfile can be used as lookup but not the seq file.2. Hashfile works based on Hashed algorithm.3. The performence is more in Hashfile when it is used as a ref link(for lkp)4. we can eliminate duplicates by selecting key value in server jobs.5. Must ... Latest Answer : By using Routines we can return values but by transformers we cannot return values ... Latest Answer : An operational data store (or "ODS") is a database designed to integrate data from multiple sources to facilitate operations, analysis and reporting. Because the data originates from multiple sources, the integration often involves cleaning, redundancy ... What's the difference between Datastage Developers and Datastage Designers. What are the skill's required for this. Latest Answer : Here is a very good articles on these differences... whic hhelps to get an idea.. basically it's depends on what you are tring to accomplishwhat are the requirements for your ETL tool? Do you have large sequential files (1 million rows, for example) that ... Read Answers (1) | Asked by : neelu
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
