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

If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

0 Answers  

Aggregator transformation is having fields say a,b,c,d,e group by is enabled on a,b,c with sorted input,How the aggregator transformation process the i/p data?or in which way i/p comes to agg transformation

1 Answers   TCS,

When do you use sql override in a lookup transformation?

0 Answers  

Briefly explain the aggregator transformation?

0 Answers  

write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.

5 Answers  

how to obtain performance data for individual transformations.

2 Answers  

How to recover sessions in concurrent batches?

3 Answers  

how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

0 Answers  

Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its possible to Create 3parameters at a time? If Possible which one will fire FIRST?

6 Answers   Accenture, HCL,

what is the difference between look up and joiner(don't say joiner sopport only = where as look up support non-equijoin).

3 Answers   IBM, ITC Infotech,

How can we use batches?

0 Answers  

What is target update override

2 Answers   CTS,