what r d pre-requiste for update strategy transformation,
and differnce between delete n truncate in target session
properties for update strategy
- 2 Answers
- 3387 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
What is the advantage of informatica?
Write the program through which the records can be updated?
How to convert multiple rows to single row (multiple columns) in informatica
What are the components of Informatica? And what is the purpose of each?
Design a mapping to load the cumulative sum of salaries of employees into target table?
tell me about your project functionality
Explain the different kinds of facts.
Explain the difference between a data warehouse and a data mart?
What is domain and gateway node?
Design a mapping to load a target table with the following values from the above source?
What are the restrictions of union transformation?
What is a transaction control transformation?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
scenario where i can use only concurrent execution of workflow.
expain about the tune parameters?
