why cant we put a sequence generator or upd strategy
transformation before joiner transformation?
Answers were Sorted based on User's Feedback
Answer / 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 |
what is galaxy repository?
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?
explain different levels in pushdown optimization with example?
What are the types of schemas we have in data warehouse.
How to delete first 3 rows & last 3 rows in target table in informatica
when we use lookup,if have 5 records,if i dont need 1st and 2nd records..what will be the procedure to achieve by using lookup?/
If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?
According to his methodology what all you need before you build a datawarehouse
what is data modelling? what are types of modelling?In which suituation will use each one?
What is dimensional table?
Hi, What is exactly node ? what is exactly domain ? How loadbalancer will work ? what is Integration service (IS) ? Can anyone give me exact scenario when I click on start workflow in the workflow manager ? (Note : I am not expecting answer like, node means logical representation of a machine and domain will contain multiple nodes .I gone through Informatica help but I couldn’t understand. I am expecting exactly what is happening in background detailed explanation or Pictorial representation will be highly appreciation ) Advance thanks
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)