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

Explain connectivity between datastage with datasources?

966


In Datastage, how you can fix the truncated data error?

1144


Why we use surrogate key?

1208


Can you explain engine tier in information server?

1109


options available in sequence job to run,validate?

1296


root tree will find which is server job and which is parallel job?

1944


What is usage analysis in datastage?

1290


What are data elements?

1156


What a datastage macro?

1044


Can we use target hash file as a lookup ?

3311


Describe routines in datastage? Enlist various types of routines.

995


What all are the different way to run a job?

1077


Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...

4179


How many types of views are there in a datastage director?

1269


Is the value of staging variable stored temporarily or permanently?

981