| |
GeekInterview.com > Interview Questions > Data Warehousing > DataStage
| Print | |
Question: surrogate key
Answer: What is the Disadvantage of surrogate key stage? |
| July 07, 2008 23:52:15 |
#1 |
| debojyoti_datastage |
Member Since: July 2008 Total Comments: 1 |
RE: surrogate key
|
The main disadvantage of this stage comes when you use it second time around..
There you have to give the initial value of the surrogate key....
I faced the similar situation and the only way i found was to write a unix shell script which would give me max value of the surrogate key column.
Increase it by 1 in the script and run the job passing that value as the paramater...
which would be used as the initial value |
| |
Back To Question | |
