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...

What is the surrogate key? what is the use of surrogate key? how to Create surrogate key Generator in scd2 in 8.5?

Answer Posted / karan am

surrogate key is alternate to primary key, in order to maintain historical data.

The key source can be a state file or a database sequence. If you are using a database sequence, the sequence must be created by the Surrogate Key stage. You cannot use a sequence previously created outside of DataStage.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

1193


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

1265


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

1134


How do you run datastage job from the command line?

1075


What is the difference between passive stage and active stage?

1507


What is a quality stage in datastage tool?

1063


how to add a new records into source?

1981


Can you explain engine tier in information server?

1110


Enlist various types of routines in datastage.

1228


why do u need the IOS upgradation in a FC switch

2268


How to implement complex jobs in data stage?

1098


State the difference between an operational datastage and a data warehouse?

1121


hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2847


How to manage date conversion in Datastage?

1118


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?

2217