Hi,
I've a mapping with flat file source
The target update override property for the target table is
using update
stmt.
There is no update strategy between source and target.
Also The session has the target properties as
Insert , Update as update options checked.
Does this mean that recs will be inserted only and the
update override will
not be applied at all.
Thanks
- 1 Answers
- 1876 Views
- I also Faced
- E-Mail Answers
Answer / Ravi Shekhar Rai
Yes, in your current mapping setup, records will be inserted only if they do not already exist in the target table. The update override property is set to use an update statement, but there is no update strategy specified between the source and target tables. Since you have checked both insert and update options for the session, new records will be inserted if they are not present in the target table, and existing records will be updated if they match the conditions specified in the update statement.
| Is This Answer Correct ? | 0 Yes | 0 No |
Mention few test cases and explain them?
working of line item dimension......pls,tell overall flow
What is factless fact schema?
what is the difference steps for data modeling?
how to answer the question "explain project architecture" in informatica pls any one who has the answer pls send the answer to this mail id "karumanchisrinu@gmail.com
Can anyone tell me what are the roles and responsibilities of informatica support ( L1, L2, & L3 ) Team?
1 Answers IBM, Saama Tech, Wipro,
what is HISTOGRAM? how to generate statistics?
What is staging area referring to?
What is tracing level?
Explain me ETL project architecture in Detail?
what is the indicator file and where it is used?
Can u access a repository created in previous version of Informatica?
Teradata 
