Is there any possibility to generate alphanumeric surrogate key?

Is there any possibility to generate alphanumeric surrogate
key?

Question Posted / sourya2009

3 Answers
11776 Views
ABC, IBM, I also Faced
E-Mail Answers

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

Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.

0 Answers

How many Key we can define in remove duplicate stage?

0 Answers CTS,

data stores in which location while using data set stage as the target?

1 Answers IBM, TCS,

Why we use parameters instead of hard code in datastage.

2 Answers IBM,

Distinguish between informatica & datastage. Which one would you choose and why?

0 Answers

Can you explain engine tier in information server?

0 Answers

Does datastage support slowly changing dimensions ?

0 Answers

1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.

0 Answers

How a server job can be converted to a parallel job?

0 Answers

If you want to use a same piece of code in different jobs, how will you achieve this?

0 Answers

Hi guys, Design job sequence, we have 3 sources, in that 1st source in abort then only run the remaining sources.. How please design the job. Thanks.

2 Answers IBM,

What is a ds designer?

0 Answers

For more Data Stage Interview Questions Click Here