Interested to Buy Any Domain ? << Click Here >> for more details...
What is up date strategy and what are the options for update
strategy?
- 2 Answers
- 10484 Views
- I also Faced
- E-Mail Answers
Answer Posted / mkolari
We can use update strategy at two different levels
1) within a session :- When you are configuring a
session you can give instructions to treat a)all rows as
insert b)all rows as update c)data driven (use instructions
coded into the session mapping to flag rows for different
database operations.)
2) within mapping :- You can flag rows for
insert,update,delete or reject.
Don't forget to set "Treat source rows as" to Data Driven
in the session properties if you are flagging rows within
the mapping.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Explain incremental aggregation in informatica
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
In informatics server which files are created during the session rums?
How does a sorter cache works?
What are active transformations.
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
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)
How do you promote a non-reusable transformation to reusable transformation?
Explain lookup transformation source types in informatica
What is the meaning of up gradation of repository?
Different circumstance which drives informatica server to expel records?
What is decode in static cache?
What is the surrogate key?
How to differentiate between the active and passive transformations?
