Is there any possibility to generate alphanumeric surrogate
key?

Answers were Sorted based on User's Feedback



Is there any possibility to generate alphanumeric surrogate key?..

Answer / bharath

It is not possible to generate alphanumeric surrogate key
in datastage.

Is This Answer Correct ?    18 Yes 0 No

Is there any possibility to generate alphanumeric surrogate key?..

Answer / datastage4you

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

Is there any possibility to generate alphanumeric surrogate key?..

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

Post New Answer

More Data Stage Interview Questions

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

0 Answers   Wipro,


Explain the functionality of your current project?

1 Answers   IBM, Miles Software,


what about data stage requirement

1 Answers  


what are the types of nodes

4 Answers   HCL, TCS,


How do you run datastage job from the command line?

0 Answers  






How can we improve the performance in datastage?

0 Answers  


if the source file is CID,CCODE,CONNDATE,CREATEDBY 0000000224,1000,20060601,CURA 0000000224,2000,20050517,AFGA 0000000224,3000,20080601,TUNE 0000000225,1000,20020601,CURA 0000000225,2000,20050617,AFGA 0000000225,3000,20080601,TONE AND TARGET is oracle following are the validations cid loaded with unique records leading zeors has to be deleted while loading cid in target load only customer who got early connected to company conn_date should be loaded into oracle date format cid datatype is varchar2 in target conn_date is data datatype ccode is varchar2 0000000224,1000,20060601,CURA 0000000224,1000,20060601,CURA

2 Answers  


i have 4 jobs i want run 1job should run on 1node and 2job runon 2node and.... how to make it possible?

1 Answers  


how to sort two columns in single job in datastage.

0 Answers   TCS,


1)What is ur project architecture ? 2)how to move project from developement to uat? 3)What is the difference between datastage 6,7.1 and datasttage 7.5? 4).How to do error handling in datastage? 5)3.Whta is unit testing, system testing and integration testing? 6)What is the Exact difference between BASIC Transformer and NORMAL Transformer?When we will go for BASIC Or NORMAL Transformer 7)why we use third party tools in datastage? 8)What is the purpose of Debugging stages? In real time Where we will use?

6 Answers   CTS, HCL, IBM, Wipro,


What are the steps required to kill the job in Datastage?

0 Answers  


how can we create a Sorrogate key in transformer stage? I want it in parallel mode

2 Answers   Syntel,


Categories