why cant we put a sequence generator or upd strategy
transformation before joiner transformation?
Answer Posted / bhupal
if you use the update strategy transformation before joiner in mapping, the mapping will be invalid because of data flow validation errors in mapping irrespective of operations you implemented in update strategy.
joiner transformation input should be from source qualifier transformation.
source---->sq--->seq--->
joiner---->trg
source---->sq---->
we cant create mapping like this because seq does't allows port to create and accept from other tr.
src--->sq--->
joiner--->trg
seq--->
we cant create like this. joiner inputs should be from source qualifier.
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What is a grid in Informatica?
have u done any performance tuning? how u ll do?
Explain what are the different versions of informatica?
Describe data concatenation?
What does “tail –f” command do and what is its use as an Informatica admin.
How to go to the older version for a mapping?
Differences between connected and unconnected lookup?
What do you understand by SOA of Informatica?
Explain in detail scd type 2 through mapping.
Target increases every day even though no new record was inserted
What do you understand by a term domain?
What is rank transformation in informatica
Why update strategy and union transformations are active? Explain with examples.
What is complex mapping?
Explain in detail about scd type 1 through mapping.