Is there any possibility to generate alphanumeric surrogate
key?
Answers were Sorted based on User's Feedback
You can generate AlphaNumeric surrogate key but not in surrogate stage, You need to put your logic in transformer
thanks
www.datagex.net
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / dhana
Only a primary key can be alphanumeric and the surrogate key is etl generated key and it cannot be alphanumeric and it is only numeric.
| Is This Answer Correct ? | 0 Yes | 1 No |
How many nodes supported by a one cpu in parallel jobs?
what is a force compile
what will happen if we allow duplicates in datastage lookup abort drop record 1st value of duplicate record none
how many rows sorted in sort stage by default in server jobs
how many write modes are there in ds
how can we create rank using datastage?what is the meaning of rank?
What is the difference between datastage and informatica?
Difference between sequential file and data set?
How many types of sorting methods are available in datastage?
what is the use of surogate key in datastage
What are the unit test cases you used in your project?
What is exact difference between Parallel Jobs and server Jobs..