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

What is aggtorec restructure operator?

1460


Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

2070


how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

2190


Differentiate between hash file and sequential file?

1081


Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

2228


What are the different kinds of views available in a datastage director?

1035


How we can covert server job to a parallel job?

1159


What is the difference between informatica and datastage?

1236


Is possible to create skid in dim,fact tables?

2648


What are orabulk and bcp stages?

1133


What is the difference between server job and parallel jobs?

1164


How can we improve the performance in datastage?

1108


Differentiate between odbc and drs stage?

1058


How a source file is populated?

1071


i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2723