Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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?

Question Posted / hardeepsingh83

Answers were Sorted based on User's Feedback



As per Informatica PC help guide, while adding transformations to a mapplet,we have to keep this ..

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

As per Informatica PC help guide, while adding transformations to a mapplet,we have to keep this ..

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

Post New Answer

More Informatica Interview Questions

what is the hint? how to use it to reduce the query processing in program?

3 Answers   Cegedim,

Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance..please let me know in case of any concerns...

1 Answers  

How to Migrate the UNIX SCRIPTS from SIT TO PROD?

1 Answers  

What are the different types of Type2 dimension maping?

2 Answers   CTS,

tell me 7.x and 8.x diferrencess(but not transformations)

1 Answers  

&#61656; Informatica Checkpoints

0 Answers   DELL,

In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the three dimensions by using one sequence generator is possible?If the mapping is containing single flow? And in the same case if the mapping is contaning 3 flows for the three dimensions then by using one sequence generator can we populate surrogate key (same value) to all the three dimensions?

6 Answers   IBM,

What is the procedure for creating independent data marts from informatica 7.1?

0 Answers  

What does “tail –f” command do and what is its use as an Informatica admin.

0 Answers  

What is the meaning of up gradation of repository?

0 Answers  

can we send mail when ever it get success or faulure to other mailid?(Not company mail id)

1 Answers   Puma,

difference between shortcut and reusable transformation?

2 Answers  

For more Informatica Interview Questions Click Here
Categories