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
- 5949 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 |
. Design a mapping, first two phone calls received by a customer must be represented as "Home" , "Office" and the next calls must be concatinated and represented as "Other".Look at the below tables :: Source Definition Customer Phone_Number A 9848403211 A 9812675432 A 9112356788 A 9876503276 B 9567890765 B 9876098567 AND THE TARGET IS Customer Home Office Other A 9848403211 9812675432 9112356788,9876503276 B 9567890765 9876098567 Null
How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?
What are the tasks that can be performed using sq?
What is a joiner transformation and why it is an active one?
explain different levels in pushdown optimization with example?
In Flat file, I need Header, Footer and No of rows in Last column. How will u achieve in Mapping Level(With out using Session Level Property)?
What is transformation?
In my sourse i have like ename,gender vasu,male geetha,female ram,male suma.female kesav,male in my output i need male,female vasu,geetha ram,suma kesav
Can informatica load heterogeneous targets from heterogeneous sources?
How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
when we dont use aggregator in mapping ?
Teradata 
