what r d pre-requiste for update strategy transformation,
and differnce between delete n truncate in target session
properties for update strategy
- 2 Answers
- 3397 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / abhinaw prakash
For update strategy t/r we should have Constraints defined
on the table.
Else we'll have to use Update override property in session
properties.
Delete in session property we use for deleting a record
based on condition were as truncate is for removing the
previous record from the table before inserting new set of
data.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Can informatica load heterogeneous targets from heterogeneous sources?
Can we get 1st record through Informatica(without sequence number).
How would you copy the content of one repository to another repository?
Implementation methodology
Define sessions in informatica etl?
Describe data concatenation?
What is rank transform?
How big was your fact table
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
draw informatica architecture 8.6 ?
What does update strategy mean, and what are the different option of it?
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
What is substr in informatica?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What is the benefit of partitioning a session?
