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

Name the third party tools that can be used in datastage?

0 Answers  

Define repository tables in datastage?

0 Answers  

Can we use Round Robin for aggregator?is there any benefit underlying?

3 Answers   TCS,

hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

0 Answers  

Differentiate between data file and descriptor file?

0 Answers  

What is the difference between account and directory options ?

0 Answers  

Difference between sequential file and data set?

0 Answers  

can any 1 put a difference between datastage 7.5 and 8.0 all concepts plz r mail 2 me anu4u09@gmail.com

4 Answers   IBM,

source has 2 fields like COMPANY LOCATION IBM HYD TCS BAN IBM CHE HCL HYD TCS CHE IBM BAN HCL BAN HCL CHE LIKE THIS....... AND I WILL GET THE OUTPUT LIKE THIS.... Company loc count TCS HYD 3 BAN CHE IBM HYD 3 BAN CHE HCL HYD 3 BAN CHE PLZ SEND ME ANSWER FOR THIS QUESTION..........

3 Answers   Patni,

How do you get log info into a file?

1 Answers  

What are the different options associated with dsjob command?

0 Answers  

Suppose take my name "Reddyvaraprasad" From source it is coming Reddy vara prasad Need to get As Reddyvara prasad/

4 Answers   TCS,

For more Data Stage Interview Questions Click Here
Categories