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 |
what is a force compile
What is use Array size in datastage
I have 100 records how can I load at a time from the single time
Differentiate between odbc and drs stage?
Name the different types of Lookups in Datastage?
I have 3 jobs A,B and C , which are dependent each other. I want to run A & C jobs daily and B job run only on sunday. how can we do it?
What are constraints and derivations?
Where the datastage stored his repository?
How we can covert server job to a parallel job?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
how can or from where we can get reference data in scd type2 implementation?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS