Interested to Buy Any Domain ? << Click Here >> for more details...
What is the surrogate key? what is the use of surrogate key? how to Create surrogate key Generator in scd2 in 8.5?
- 5 Answers
- 10321 Views
- SLK Software, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / suresh
surrogate key is alternate to primary key,it allows duplicates also,while maintain the hystorical data we use surrogate key
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / prabhu rathnam
Surrogate key is used to generate sequence of number from 1 to n. It increment by 1 continously and sequencly.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / siva katta
"Surrogate key" which is system generated unique numeric values.
uses:
---------
when implimenting the SCD2 $SCD3. because these scd's are needs to maintain the historical information. so there is no way to maintain the historical information with Primary key constraint,so we are gonna generate the Surrogate key for identifying the records need to take the insert or update action.
Note :
------
Surrogate key we can use for many purpose and so many cases but the above usage is one of these.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / karan am
surrogate key is alternate to primary key, in order to maintain historical data.
The key source can be a state file or a database sequence. If you are using a database sequence, the sequence must be created by the Surrogate Key stage. You cannot use a sequence previously created outside of DataStage.
| Is This Answer Correct ? | 0 Yes | 0 No |
How can we do null handling in sequential files?
What is confirmed Dimension? what is Factless Fact? give one example? What are Additive, Semi-Additive Facts?
source 1123445 I WANT OUTPUT AS DUPLICATES TO TARGET1 LIKE TARGET1 1144 NON-DUPLICATES TO TARGET2 TARGET2 235
What are the various kinds of the hash file?
in source is like seq file in date column have dd-mm-yy dddd-mmmm-yyyy mm-dd-yy yy-dd-mm yy-mm-dd i want to display only yy-dd-mm date formats only in tgt?
3) Sequential file contains data like Empno ename sal 111 abc 2000 Trgt file: Trgt1----111 Trgt2----abc Trgt3---2000
Difference between sequential file and data set?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
I have 5 different sources i want same records in 5 different targets Can you any body send me this question answer rathdsetl@gmail.com
How do you design PX Routines ?
Converting Vertical PIVOTing without using PIVOT stage in DataStage. Ex: DEPT_NO EMPNAME 10 Subhash 10 Suresh 10 sravs Output: DEPT_NO EMP1 EMP2 EMP3 10 subhash suresh sravs 2) How to implement Horizontal PIVOTing without using PIVOT stage.
Is it possible to query a hash file?
Teradata 
