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
- 4311 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 |
How to retrieve last two days updated records?
What is meant by lookup transformation?
How many repositories can we create in Informatica??
to improve the performance of aggregator we use sorted input option and use sorter t/r befor aggregator. But here we are increasing one more cache in our mapping i.e; sorter. So how can u convince that you are increasing the performance.?
What are the tasks that Loadmanger process will do?
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?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
What are the components of the workflow manager?
hi i want to install latest informatica software in my pc..can anybody help me where should i get the infomatica software..plz help me
What are steps to follow Informatica migration from 7x to 8x? Pls Explain...
What is the term PIPELINE in informatica ?
Which kind of index is preferred in DWH?
Teradata 
