what r d pre-requiste for update strategy transformation,
and differnce between delete n truncate in target session
properties for update strategy
- 2 Answers
- 3558 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vikas
Update Strategy Works on Tables and not on files. In session, Treat source rows should be data driven.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
Explain target update override in informatica
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
what is workflow varible
Can yoU use the maping parameters or variables created in one maping into another maping?
What is an expression transformation in informatica?
How does a sorter cache works?
Explain pushdown optimization $pushdownconfig parameter - informatica
What is up date strategy and what are the options for update strategy?
hi guys i have an question how do you find out weather the column is numeric or combination of char and numbers or it contains char,numeric and special characters.
what is data driven?
what is the difference between look up and joiner(don't say joiner sopport only = where as look up support non-equijoin).
if we r using aggregator we enabled sorted input but the records r not sorted what happen?
Teradata 
