Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How to generate surrogate key without using surrogate key stage?

Answer Posted / sudhir

Surrogatekey is nothing but a unique number to identify the
record in datamart. So just use a counter in StageVariable
of Transformer. Keep incrementing the counter by one for
every new inserts. This would form a surrogatekey.

Is This Answer Correct ?    4 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to clean the datastage repository?

1178


Have you used Unstructured data?

1368


What are the different common services in datastage?

1337


How to perform incremental load in datastage?

1260


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

1141


How do you reject records in a transformer?

1176


Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3847


How many areas for files does datastage have?

1214


What are the functionalities of link partitioner?

1064


Define Merge?

1374


What can we do with datastage director?

1290


What are the main features of datastage?

1349


Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

2266


What is ibm datastage flow designer?

1203


Can you explain link buffering?

1221