Answer / nanda

yes it is valid, etl maha guru watch your language buddy

cant u pass SQ and lookup to expression, yes u can

and i guess SQ is active
lookup is passive
exp is passive

examples: scds

Answer / etl guru

Hey fools, understand the question. The question is "Data
is passed from one active trans and one passive trans
into a passive transformation.Is the mapping valid or
invalid?"
The answer is: Mapping is invalid. We can never connect a
data from Active and passive transformation TO A PASSIVE
TRANSFORMATION. Can you connect output of a joiner and
Expression to an expression transformation?

Answer / etl maha guru

Hey fools, understand the question. The question is "Data
is passed from one active trans and one passive trans
into a passive transformation.Is the mapping valid or
invalid?"
The answer is: Mapping is invalid. We can never connect a
data from Active and passive transformation TO A PASSIVE
TRANSFORMATION (Coming from different pipelines, we should
take the question in this way). Can you connect output of a
joiner and Expression to an expression transformation
(where output of joiner and expression coming from
different pipelines).

Answer / jhilam roy

The answer is conditional.

1. If both the active and passive transformations belong to
the same pipeline, then the answer is VALID. Example: see
SCD mappings.

2. On the other hand, if the active and the passive
transformation belong to two different pipelines, then the
answer is INVALID. Example: you can try it on your own and
cross-check the correctness of the answer.

Hope, this clarifies any doubt.

Answer / prasuna

Sorry..we can connect an active with an Passive
transformation..
for example when we create Mappings for SCD2 ..we connect
Filter with Expression..where Filter is Active And
Expression is Passive.

Answer / venkat

hey maha guru ur wrong.
let me see the scd example said by nanda exactly working.

Answer / mohan

it's valid

Answer / uma

Please explain the above with an example.

Answer / n.srinivasan

Its valid only
If any one feel INVALID please give me your explanation

Answer / yadav

we cant connect one active and one passive in a same pipeline.
but in the case of seq genarator t/r it can possible.
b'coz seq generator doesnt have input port

What is difference between a gateway node and worker node?

0 Answers  

how many tasks are there in informatica ?

15 Answers   DELL, iGate, TCS,

How to calculate the cache size if say we are doing a performance check on a mapping and found that a particular cache needs to be changed. Is there a formula to calculate this! i know that informatica has a auto option available but how to calculate manually?

1 Answers  

During the running session, output files are created by informatica server. Enlist few of them.

0 Answers  

I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.

3 Answers  

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

2 Answers   Sapient,

Hi, Can someone send me the DWH and Informatica FAQ's at vanibv6@gmail.com Thanks in Advance, Vani

2 Answers   Wipro,

Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

0 Answers  

difference between shortcut and reusable transformation?

2 Answers  

How to delete the (flat file) data in the target table after loaded.

2 Answers   TCS,

What is the default join that source qualifier provides?

3 Answers   Informatica,

My source table having some records ,i want load 1st record and last record into one target?

3 Answers   iGate,