Data is passed from one active trans and one passive trans
into a passive transformation.Is the mapping valid or
invalid?
- 18 Answers
- 30478 Views
- L&T, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / jyothika
for eg,when v connect filter transformation (active) and
exp trfn (passive) to exp trfn.v get a notification
saying "not allowed".
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / 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 |
Answer / chandru
if the date is passed from one active an one passive cannot be connected to the passive transformation the mapping is not valid
but there is a possible way if we have expression(passive) an aggreatror(active) we can connect these active an passive transformation through joiner (active) transformation it is possible
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / suhel shaikh
Yes its valid we can pass the data from an active trans to
passive trans.
| Is This Answer Correct ? | 2 Yes | 4 No |
Answer / zaheer
No, it is not possible to move data from ACTIVE & PASSIVE to
PASSIVE. Either both transformation should be ACTIVE or
PASSIVE in pipeline.
| Is This Answer Correct ? | 3 Yes | 5 No |
How can we reset Sequence Generator, when we move objects from Dev Environment to QA env?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What is an unconnected transformation?
Whatis the difference between View and Materialized View ?
tell me 5 session failure in real time how can you solve that in your project?
How to delete first 3 rows & last 3 rows in target table in informatica
Define Pmrep command?
What is CDC? How to implement CDC?
Could any one to tell How to use the Oracle Analytic functions in Informatica?
how can we check whether a particular cache is static or dynamic?
What is the procedure to load the fact table.Give in detail?
What is intricate mapping?
Teradata 
