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 can we create a Sorrogate key in transformer stage? I
want it in parallel mode

Answer Posted / varma

In transformer Properties, there is a tab called “Surrogate Key”. Here we can define it.
We can select from
a. Flat file : State file which holds the SK values and generates SK values.
b. DB Sequence: Database sequence object to use to generate the SK values.

Is This Answer Correct ?    11 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

I have a few records just I want to store data in to targets cycling way how?

2303


project Steps,hits, Project level HArd things,Solved methods?

2065


What are the job parameters?

1161


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

1092


Notification Activity

1350


Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1371


How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...

1446


Define meta stage?

1144


How a routine is called in datastage job?

1045


Define repository tables in datastage?

1100


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

1030


Can you explain link buffering?

1111


Can you implement SCD2 using join, transformer and funnel stage?

1501


What are the functionalities of link partitioner?

974


What is quality stage?

937