Interested to Buy Any Domain ? << Click Here >> for more details...
what r d pre-requiste for update strategy transformation,
and differnce between delete n truncate in target session
properties for update strategy
- 2 Answers
- 4266 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
How are the sources and targets definitions imported in informatica designer?
How to update or delete the rows in a target, which do not have key fields?
Explain the types of lookup transformation?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
How to differentiate between the active and passive transformations?
How we can create indexes after completing the loan process?
what is SDLC way of code development?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
Explain how many types of dimensions are available in informatica?
What is the difference between informatica 7.0 and 8.0?
How do you load first and last records into target table?
write a query to retrieve the latest records from the table sorted by version(scd)
differences between service based and product based?
