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

  1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

HOW WILL YOU IMPLEMENT SURROGATE KEY IN SCD BY USING
SURR_KEY GENERATOR,THE VALUE OF S_KEY SHOULD NOT REPEAT
EVEN IF THE JOB IS COMPILED REPEATEDELY?

Question Posted / maruthi

Answers were Sorted based on User's Feedback



HOW WILL YOU IMPLEMENT SURROGATE KEY IN SCD BY USING SURR_KEY GENERATOR,THE VALUE OF S_KEY SHOULD ..

Answer / kpk

Pass the last key (last primary key or the last value in the
seq) as parameter.

Is This Answer Correct ?    9 Yes 4 No

HOW WILL YOU IMPLEMENT SURROGATE KEY IN SCD BY USING SURR_KEY GENERATOR,THE VALUE OF S_KEY SHOULD ..

Answer / prasad

this type of problem is clear in datastage8.0.1 version by
using the new surrogate key generator stage.
But whenever we use below 8th version we can will face the
problem in the case of surrogate key.to overcome this
problem use the help of the routines.
we have to pass the maximumvalue of the surrogate key
through the routine.when ever we run the job second time the
routine will pass the max value and it will generate the
sequence from that number only

Is This Answer Correct ?    4 Yes 0 No

HOW WILL YOU IMPLEMENT SURROGATE KEY IN SCD BY USING SURR_KEY GENERATOR,THE VALUE OF S_KEY SHOULD ..

Answer / kiran

If you want the SCD stage to generate new surrogate keys by
using a key source that you created with a Surrogate Key
Generator stage, you must use the NextSurrogateKey function
to derive the Surrogate Key column.

Is This Answer Correct ?    2 Yes 0 No

HOW WILL YOU IMPLEMENT SURROGATE KEY IN SCD BY USING SURR_KEY GENERATOR,THE VALUE OF S_KEY SHOULD ..

Answer / madhav

canu give ans in depth

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Data Stage Interview Questions

What are the various kinds of containers available in datastage?

0 Answers  

parallel jobs run on cluster machines. server jobs run on smp and mpp. What do mean by cluster mechines and SMP and MPP..?

3 Answers  

what is data mapping

2 Answers  

in datastage interview qustion source target ------- ------- 12345 1 2 3 4 5

3 Answers   IBM, YCS,

What is the difference between server job and parallel jobs?

0 Answers  

Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

0 Answers   TCS,

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

0 Answers  

Thanks to all people who are posting their comments...

1 Answers   CTS,

Explain usage analysis in datastage?

0 Answers  

In my project source data comes from MAINFRAME in files.so,This time data is coming as a binary file...I know for binary data we use Complex flat file stage..I have used it also..but on 'view data' data is not coming correctly..as it in MAINFRAME.give me some ideas..

2 Answers  

What is staging variable?

0 Answers  

Pls tell me what is troubleshooting in datastage view?

1 Answers  

For more Data Stage Interview Questions Click Here
Categories