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 WILL YOU IMPLEMENT SURROGATE KEY IN SCD BY USING
SURR_KEY GENERATOR,THE VALUE OF S_KEY SHOULD NOT REPEAT
EVEN IF THE JOB IS COMPILED REPEATEDELY?

Answer Posted / kpk

Pass the last key (last primary key or the last value in the
seq) as parameter.

Is This Answer Correct ?    9 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What all the types of jobs you developed?

1115


What are the difference types of stages?

1132


explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

2404


options available in sequence job to run,validate?

1255


how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

3263


What are the different type of jobs in datastage?

1001


what is use of SDR function?

5125


What is the difference between an operational datastage and a data warehouse?

1087


Difference between ‘validated ok’ and ‘compiled’ in data stage?

1190


How to find value from a column in a dataset?

2146


Define orabulk and bcp stages?

1066


What are stage variables?

1137


What is the use of hoursfromtime() function in transformer stage in datastage?

999


Describe link sort?

959


Terminate Activity

1230