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 / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Performance tuning in UNIX for informatica mappings?

2246


What is informatica metadata and where is it stored?

670


What are the modules in Power Center

1317


What is union transformation in informatica?

802


Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

1504






How many transformations can be used in mapplets.

1555


what is the -ve test case in your project.

1975


What is the difference between writing a joiner query in ANSI style and THETA style?

2017


What are the transformations that are not supported in mapplet?

682


What is meant by lookup transformation? Explain the types of lookup transformation?

652


How to extract sap data using informatica?

693


What is persistent lookup cache?

690


expain about the tune parameters?

2006


have u done any performance tuning? how u ll do?

1962


What is informatica?

771