What is the surrogate key? what is the use of surrogate key? how to Create surrogate key Generator in scd2 in 8.5?
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 SEE THE DATA IN DATASET?
12 Answers IBM, TCS,
SOURCE CITY NAME1 NAME2 NAME3 NAME4 BGLR HCL CSC IBM TCS TARGET CITY COMPANY BGLR HCL BGLR CSC BGLR IBM BGLR TCS
What are data elements?
What is a merge in datastage?
How can u execute the sql query through unix? What is the Primary key for Dimension table? what is the primary key for Fact table?
What are the differences between datastage and informatica?
How can we read latest records in a text file named file1.txt using seq file stage only? file1 having 100 records in that 5 record sare latest records.How can we read that latest records?
What is Fastly Changing Dimension?
I HAVE EMP TABLE, 4 COLS R THERE COL1,COL2,COL3,COL4 ID-- 101,102,103,104 SAL-- 1000,4000,2000,5000 DATE-- COLUMN. I WANT TO DISPLAY THE DATA PREVIOUS MONTH HIGEST SAL ?
How did you reconcile source with target?
What is exact difference between Parallel Jobs and server Jobs..
Pls tell me what is troubleshooting in datastage view?