Data is passed from one active trans and one passive trans
into a passive transformation.Is the mapping valid or
invalid?
Answer Posted / etl maha maha maha muduru
yes valid.suppose take sequence generator t/r drag the
nextval port into exp t/r from exp t/r drag all ports into
router t/r,from router t/r drag default group into one target.
when u connect default group into target then it is passive.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What are the conditions needed to improve the performance of informatica aggregator transformation?
Why update strategy and union transformations are active? Explain with examples.
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
Different circumstance which drives informatica server to expel records?
Did u used latest transformations of 8.6.0? for what?
What are the different clients of powercenter?
What is mapplet in informatica?
What are the types of data warehouses?
What are ETL Tools?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Explain in detail scd type 2 through mapping.
What are the transformations that are not supported in mapplet?
Can we override a native sql query within informatica?
How to partition the Session?
Name the different lookup cache(s)?