 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 : Primary Key does not allow data duplications for actual source data. We cannot maintain historical data of each record using PK.SID acts as a primary key in target WH systems, that allows data duplications and maintains complete historical data along ... Latest Answer : Natural key is nothing but primary key, it uses to identify a record uniquly.Surrogate key is to identify a entity uniquly.Regards,Veeru. ... Read Answers (3) | Asked by : CNDRAA 1 1. Difference between Hashfile and Sequential File?. What is modulus?2 2. What is iconv and oconv functions?.3 3. How can we join one Oracle source and Sequential file?.4 4. How can we implement Slowly Changing Dimensions in DataStage?.5 5. How can we implement Lookup in DataStage Server jobs?.6 6. What are all the third party tools used in DataStage?.7 7. what is the difference between routine and transform and function?.8 8. what are the Job parameters?.9 9. Plug-in?.10 10.How can we improve Read Answers (1) | Asked by : Zias Latest Answer : You can generate through system variable in transformer which is built-in name is keymgt. You don't have remember full name and in parallel you can generate through surrogate key generator. ... Read Answers (4) | Asked by : praveen Tags : Parallel Server Latest Answer : the Surrogate key will be the key field in the dimensions. ... Read Answers (1) | Asked by : mallikharjuna reddy Latest Answer : Surrogate key generator is available only in Parralle edition in Server mode you will have to use stage variables or pre-defined variables like @inrownum, @outrownum ... What is the Disadvantage of surrogate key stage? Latest Answer : to my concern if the data is not properly processed on nodes..in such suitations this surrogate key generates holes(simply skips the ordering )ex:aa-1bb-2ba..bg...cc-3dd-4ddd-5here for ba and bg do not have seq key ,here ba and bg have holes ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
