Series: Subject: Topic:
Question: 667 of 1135

why do we use reusable sequencegenerator transformation only in mapplet?

Asked by: Interview Candidate | Asked on: Oct 16th, 2006
Showing Answers 1 - 3 of 3 Answers

Answered On : Nov 16th, 2006

The relation between reusable sequence generator and maplet is indirect.Reusable Sequence generator are preferably used when we want the same sequence (that is the next value of the sequence) to be used in more than one mapping (may be because this next value loading the same field of same table in different mappings and to maintain the continuity its required)suppose there are two mappings using a reusable sequence generator and we run the two mappings one by one. here if the last value for the sequence generator for the mapping1 run is 999 then the sequence generator value for second mapping will start from 1000.this is how we relate reusable sequence generator and maplet.

Login to rate this answer.

Answered On : Jun 11th, 2007

Hi Question is, Are you sure its going to start with the 1000 number after the 999. By default for reusable SEQUENCE, it has a cache value set to 1000, that's why it takes 1000 else if you only have 595 records for the 1st session and automatically the 2nd session will start with 1000 as the sequence number bcos the cache value is set to it.I got another question.Is it possible to change Number of Cached Values always to 1 instead of changing it after each time the session/sessions is/are run.Thanks Philip

Login to rate this answer.

Answered On : Oct 31st, 2007

Hi,The solution provided is correct. I would like to add more information into it.Reusable Sequence Generator is a must for a Mapplet:Mapplet is basically to reuse a mapping as such if a non- reusable sequence generator is used in mapplet then the sequence of numbers it generates mismatches and creates problem. Thus it is made a must.

Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions



twitter fb Linkedin GPlus RSS


Interview Question

 Ask Interview Question?


Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.