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?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

3605


What are the reusable transformations?

779


Define Pmrep command?

723


Explain the mapping variable usage example in informatica

725


Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2012






I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1233


What is powercenter on grid?

813


What are the modules in Power Center

1317


What is DR strategy for Informatica project?

806


Is it possible to define a single node as a Gateway node as well as worker node?

763


Briefly explain the aggregator transformation?

689


Which transformation is needed while using the Cobol sources as source definitions?

817


What are batches?

712


What is the difference between stop and abort in informatica

760


What are the conditions needed to improve the performance of informatica aggregator transformation?

686