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 are the components of datastage?
How complex jobs are implemented in datstage to improve performance?
what is push and pull technique??? I want to two seq files using push technique import in my desktop what i will do????
what is advantages of snowflake when it is used?
I have 2 jobs.I want to ru job B if job A has run 3 times.How can I achieve this through datastage
I have a few records all are same structures data, I want to store data in multiple targets how?
How much data u can get every day? 2)which data ur project contains? 3) what is the source in ur project?what is the biggest table & size in ur schema or in ur project?
What is a quality stage in datastage tool?
Define repository tables in datastage?
Difference between server jobs & parallel jobs?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
How to remove duplicates in transformer stage? in parallel mode