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
What is the difference between router and filter?
Explain dynamic target flat file name generation in informatica
Explain the code page compatibility?
server hot-ws270 is connect to Repository B. What does it mean?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What is a code page?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
In development project what is the process to follow for an etl developer from day1
What is a router transformation?
what are 3 tech challenges/ common issues you face?
Global and Local shortcuts. Advantages.
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What do you mean by enterprise data warehousing?
explain one complex mapping with logic? sales project?
What is the use of code page?