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

Define Job control?

1228


Can you explain kafka connector?

1380


Explain Quality stage?

1211


whom do you report?

1986


What are the various kinds of the hash file?

1200


what is flow of project?

2059


What is staging variable?

1153


What is a merge in datastage?

1345


What is the difference between the local container and shared container?

1146


Where the datastage stored his repository?

1141


AGGREGATOR default datatype

1526


Explain usage analysis in datastage?

1224


What are transforms and what is the differenece between routines and transforms?

1109


if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

2288


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

2415