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 are two types of processes that informatica runs the session?

2 Answers  


How can we use mapping variables in informatica? Where do we use them?

0 Answers  


how to load dimension table and fact table. plz tell me the steps.

0 Answers   Cognizant, IBM,


empno sal 1 8000 2 9000 3 8000 4 1000 how to get highest sal wise rankings in rank t/r.

3 Answers  


What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?

2 Answers  






how to import multiple flat files in to single target where there is no common column in the flat files

2 Answers   TCS,


Can yoU use the maping parameters or variables created in one maping into another maping?

2 Answers  


How does the session recovery work.

1 Answers  


WE HAVE 10 RECORDS IN SOURCE IN THAT GOOD RECORDS GO TO RELATIONAL TARGET AND BAD RECORDS GO TO TARGET FLAT FILE ? HERE IF ANY BAD RECORDS MEANS ITS LOAD INTO FLAT FILE AND SEND AN EMAIL , IF NO BAD RECORDS MEANS NO NEED TO SEND EMAIL . PLZ HELP ME ...

1 Answers  


I have 2 Sources,If 1st one Read sucessfully,Then only it has to move to read 2nd source.How can i do in INFORMATICA.

4 Answers  


Hi experts, For informatica developer, in real time, normally how much we use sql and plsql?

2 Answers   Infotech,


Explain how to import oracle sequence into informatica?

0 Answers  


Categories