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 to create user defined environment varibale(parameter)?
i want anser this question empno,ename,sal 12,mmm_ww,200 13,nnn_xx,300 14,bbb_qq,400 which stages are take which types of logicks are doing pls help me i don't need "_"ex nnnxx this type i want
What is the differentiate between data file and descriptor file?
Explain connectivity between datastage with datasources?
What are stage variables and constants?
how to find out number of records imported into source file?
How to LOG 'unmatched Master' records and 'Reject Updates' in log files using MERGE stage?
What is the purpose of interprocessor stage in server jobs?
What is the use of surrogate key stage?
Terminate Activity
What is apt_config in datastage?
Hi friends,Two input files, wants to validate only if the reference data has '0' otherwise no validation should be done..how to do this??