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
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 |
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 |
what type of documents you receiving from client later wt can you do? what type of documents have to prepare?
can a port in expression transf be given the name DISTINCT
what are the types of Data warehousing ?
what is the use of Data Mart?
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
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.
what is lookup chache?
what is workflow varible
How to add source flat file header into target file?
which transformation should we use to get the 5th rank member from a table in informatica?can we achieve this in sql?
As union transformation gives UNION ALL output, how you will get the UNION output?