Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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



Data is passed from one active trans and one passive trans into a passive transformation.Is the ma..

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

Is This Answer Correct ?    15 Yes 1 No

Data is passed from one active trans and one passive trans into a passive transformation.Is the ma..

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?

Is This Answer Correct ?    15 Yes 2 No

Data is passed from one active trans and one passive trans into a passive transformation.Is the ma..

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).

Is This Answer Correct ?    12 Yes 0 No

Data is passed from one active trans and one passive trans into a passive transformation.Is the ma..

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.

Is This Answer Correct ?    8 Yes 0 No

Data is passed from one active trans and one passive trans into a passive transformation.Is the ma..

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.

Is This Answer Correct ?    9 Yes 2 No

Data is passed from one active trans and one passive trans into a passive transformation.Is the ma..

Answer / venkat

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

Is This Answer Correct ?    2 Yes 0 No

Data is passed from one active trans and one passive trans into a passive transformation.Is the ma..

Answer / mohan

it's valid

Is This Answer Correct ?    6 Yes 5 No

Data is passed from one active trans and one passive trans into a passive transformation.Is the ma..

Answer / uma

Please explain the above with an example.

Is This Answer Correct ?    1 Yes 0 No

Data is passed from one active trans and one passive trans into a passive transformation.Is the ma..

Answer / n.srinivasan

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

Is This Answer Correct ?    2 Yes 1 No

Data is passed from one active trans and one passive trans into a passive transformation.Is the ma..

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

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Informatica Interview Questions

Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?

0 Answers   IBM,


Can we change Dynamic to Static or Persistent cache? If so what happens?

0 Answers   TCS,


How can one know that a table has indexes and is partitioned? How data will be pulled from Partitions in Oracle for Informatica?

1 Answers  


Filter transformation in the condition one of the data is NULL would the record be dropped.

2 Answers  


4 yrs etl devloper roles and responsibilities?any body give solutions

0 Answers   TCS,






Differentiate between a database and data warehouse?

0 Answers  


In CSV flat file date are in the following format. dd/mm/yyyy (05/01/2005)and d/m/yyyy (5/1/2005) and dd/m/yyyy (05/1/2005) and d/mm/yyyy (5/01/2005). It should be load to target in a unique format. How will you implement this?

1 Answers  


How can you complete unrcoverable sessions?

1 Answers  


Hi all, iam new to informatica, can anyone tell me what is unit testing & how it is done? thank u

3 Answers  


What is a sequence generator transformation?

0 Answers  


while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?

1 Answers   IBM,


what are the transformations that are used in data cleansing ? and how data cleansing takes place ?

3 Answers  


Categories