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
- 36254 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 |
in my source i have 100 records, and 3 targets, i want to load 1st record into 1st target,2nd record into 2nd target,3rd record into 3rd target again 4th target into 1st target and vice versa,how to achieve this?
How to delete duplicate records in a flat file source?
Are there any types of Dynamic Caches in informatica
list out all the transformations which use cache?
who to split dimentions into sub dimention
If we can implement SCD TYPE 1 AND 2 IN A SINGLE MAPPING.. CAN WE SEE THE RESULT IN A SINGLE OUTPUT? I MEAN I WANT THE RELSULT OF BOTH SCD 1 AND 2 TO BE SEEN IN A SINGLE RUN?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Can you create a flatfile target
Can anyone tell me the new features in Informatica 9 Version?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
How identifying bottlenecks in various components of informatica and resolving them?
To import the flat file definition into the designer where should the flat file be placed?
Teradata 
