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

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

4188


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

1153


why do u need the IOS upgradation in a FC switch

2281


how can we create rank using datastage?what is the meaning of rank?

8787


Why fact table is in normal form?

1238


What are some prerequisites for datastage?

1096


Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3790


client know skid info?

2079


What are the different plug-ins stages used in your projects?

1078


How to perform incremental load in datastage?

1198


Define project in datastage?

1092


Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1408


Lookup constraints

1249


There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

2240


Nls stands for what in datastage?

1188