Data is passed from one active trans and one passive trans
into a passive transformation.Is the mapping valid or
invalid?
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 |
Hi i am new to Informatica. I have few question's in Informatica. Can any one respond, it will be appricaited. Q.Is Flat File Contains the Dynamic Cache?
What is the difference between router and filter?
what is the difference between onsite & client site?
What is the term PIPELINE in informatica ?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
explain about lookup t/r?
Transformer is a __________ stage option1:Passive 2.Active 3.Dynamic 4.Static
what is the flat file partition and where have to specify it
In Joiner Transformation, how to identify the master and detail tables if one is from Oracle and the other is from Sybase.
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
What is a parameter When and where do you them when does the value will be created
When will you use SQL override in a lookup transformation?