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
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
What are the reusable transformations?
Define Pmrep command?
Explain the mapping variable usage example in informatica
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
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.
What is powercenter on grid?
What are the modules in Power Center
What is DR strategy for Informatica project?
Is it possible to define a single node as a Gateway node as well as worker node?
Briefly explain the aggregator transformation?
Which transformation is needed while using the Cobol sources as source definitions?
What are batches?
What is the difference between stop and abort in informatica
What are the conditions needed to improve the performance of informatica aggregator transformation?