As per Informatica PC help guide, while adding
transformations to a mapplet,we have to keep this in mind:
If you use a Sequence Generator transformation, you must
use a reusable Sequence Generator transformation.
May i know the reason behind this?

Answers were Sorted based on User's Feedback



As per Informatica PC help guide, while adding transformations to a mapplet,we have to keep this ..

Answer / santsoh kumar sarangi

reusable sequence generator will give some range of value
for one instance like 0-1000 for one instance and 1001-2000.
so it will not allow ambiguity in the number.

If you not use reusable sequence generator then if mapplet
is used by two mapping then it may happen that number one
will come to first mapping and number two will go to the
second mapping which will create confusion.

For that reason mapplet ask for reusable sequence generator.

Let me know if i am wrong.
Santsoh Kumar Sarangi

Is This Answer Correct ?    1 Yes 0 No

As per Informatica PC help guide, while adding transformations to a mapplet,we have to keep this ..

Answer / hardeepsingh83

I am not able to identify the reason behind this point.
If I am using a mapplet in 2 diff mappings and using
reusable seq generator(as per infmt guide) then both
mappings will get seq values accoriding to same Seq gen
transformation, which may not be required always or create
data issues.

Any body knows the exact reason behind it?

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More Informatica Interview Questions

what type of documents you receiving from client later wt can you do? what type of documents have to prepare?

2 Answers   CGI,


can a port in expression transf be given the name DISTINCT

3 Answers  


what are the types of Data warehousing ?

1 Answers  


what is the use of Data Mart?

5 Answers   IBM,


What is checksum termnology in informatica? Where do you use it ?

3 Answers   Chase, Cognizant, Deloitte,






How to convert multiple rows to single row (multiple columns) in informatica

0 Answers   Informatica,


I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.

3 Answers  


what is lookup chache?

1 Answers   Patni,


what is workflow varible

1 Answers   HP,


How to add source flat file header into target file?

3 Answers   Logica CMG,


which transformation should we use to get the 5th rank member from a table in informatica?can we achieve this in sql?

6 Answers   IBM,


As union transformation gives UNION ALL output, how you will get the UNION output?

0 Answers   Informatica,


Categories