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

Define Routines and their types?

1125


How many types of hash files are there?

1139


Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

3141


What are datastage sequences?

1077


What is the precedence of stage variables,derivations, and constraints?

1045


What is a merge in datastage?

1221


What are the various kinds of the hash file?

1112


What are the important features of datastage?

1066


how to abort the job its matain duplicates?

2547


Can you explain players in datastage?

1163


What is the difference between in process and inter process?

1105


Explain the datastage parallel extender (px) or enterprise edition (ee)?

1190


how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

5069


What are the types of containers?

1162


Describe routines in datastage? Enlist various types of routines.

965