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

what is the use of surogate key in datastage

Answer Posted / navin

DW is for to maintain historical & current data.
if use Natural key as primary key in DW we can't maintain
history.so we need a physical key in DW i.e is generated by
ETL developer .In DW we have develop a key called surrogate
key.

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

client know skid info?

2084


How do you import and export the datastage jobs?

1159


What is use Array size in datastage

1780


What is ibm datastage flow designer?

1150


What is meta stage?

1183


1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do

2085


What are the different common services in datastage?

1287


What a datastage macro?

1061


How to implement complex jobs in data stage?

1112


what are the devoleper roles in real time? plz tell i am new to datastage....

2164


Define Routines and their types?

1187


What is merge stage?

1317


What are the functionalities of link partitioner?

1022


How can we improve performance of data stage jobs?

1017


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

2495