Interested to Buy Any Domain ? << Click Here >> for more details...
Data is passed from one active trans and one passive trans
into a passive transformation.Is the mapping valid or
invalid?
- 18 Answers
- 36224 Views
- L&T, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 ? | 16 Yes | 1 No |
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 |
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 |
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 |
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 |
Answer / n.srinivasan
Its valid only
If any one feel INVALID please give me your explanation
| Is This Answer Correct ? | 2 Yes | 1 No |
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 |
why we use informatica in our project?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Can we schedule a workflow(not a session) to run after completition of another workflow? Can we make a workflow depend on completition of another one?
What are Rapid changing dimensions?
WHAT IS THE NAME OF THAT PORT IN DYNAMIC CACHE WHICH IS USED FOR INSERT , UPDATE OPRATION ?
How big was your fact table
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
what is the hint? how to use it to reduce the query processing in program?
Explain in detail about scd type 1 through mapping.
Tell me about Propagate functions in informatica
What is the reusable transformation?
Explain load alternative records / rows into multiple targets - informatica
Teradata 
