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 |
difference between function and procedure...
how many datamarts we will use in real time project and when will use the datamart?pls send the replay early
how can you generate sequence number using only the sequential file stage?
Where the datastage stored his repository?
What are the important features of datastage?
what is executable in DataStage?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
What are routines in datastage?
how to handle null values using transformer stage?
Hi All, Could you please let me know whether Datastage server and px supports oredb? OREDB:It's a Oracle Retail Embedded Database.Previousely It was called as Acumate data base. It's a multidimensional database. Please help me on this issue ASAP. Thanks in advance Ashok
hi i am madan, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer
How to remove duplicates in transformer stage? in parallel mode