what r d pre-requiste for update strategy transformation,
and differnce between delete n truncate in target session
properties for update strategy
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
Scheduling properties,whats the default (sequential)
How many ways are there to create ports?
Separate from a database, an information bazaar, and an information stockroom?
What is substr in informatica?
What are Dimensional table?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
4 yrs etl devloper roles and responsibilities?any body give solutions
Can we get 1st record through Informatica(without sequence number).
What is informatica? Why do we need it?
What are the different transaction levels available in transaction control transformation?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What is native users?
Sequence generator, when you move from develoment to production how will you reset
What is the reusable transformation?
What are the data movement modes in informatica?