Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 2 Answers
- 5952 Views
- I also Faced
- E-Mail Answers
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 |
suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping?how
I have a scenario like - how can i load 1st record to Trgt1,2nd->Trgt2, 3rd->Trgt3 and again the cycle has to repeat with loading 4th->Trgt1,5th->Trgt2,6th->Trgt3?
difference between informatica 8.1.1 and 8.6? And different betweeninformatica 7x and 8x?
Explain in detail about scd type 1 through mapping.
I have 2records in target table and this record is deleted in source. Now if I run mapping twice how many records do target will have, source having 10records. Same with incrementally. Please answer me ASAP.
Which files are created during the session rums by informatics server?
What is critical mapping?
how to load the data in fact table.. using look up transformation how to view the second record. usally look up shows matching record for only one value. if i have same value its not displaying. ex: problem i faced. i have total, student no and name in table student i used aggregation transformation to display max(total). i have two same max values in total. when i look up the student name and no for this max(total), its showing only one name and no, its leaving the second one. how to rectify it. plz tel me step by step or clearly.
What are the various types of transformation?
why normalizer transformation can not used in mapplet? plzzzz answer
How i can Schdule the Informatica job in "Unix Corn Schduling tool" ?
What is the format of informatica objects in a repository?
Teradata 
