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 happens when a session fails and you click on recover?
Can we create two repositories on same database instance in oracle?
What is substr in informatica?
How you know when to use a static cache and dynamic cache in lookup transformation?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
Briefly explain the aggregator transformation?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Can we change Dynamic to Static or Persistent cache? If so what happens?
Explain the types of transformations?
How to differentiate between the active and passive transformations?
Quickly characterize reusable change?
Explain target update override in informatica
How to convert multiple rows to single row (multiple columns) in informatica
Different sorts of metadata that stores in the storage facility?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?