Interested to Buy Any Domain ? << Click Here >> for more details...
Can we update a target table (without primarykey) by using
update strategy transformation?
- 4 Answers
- 23491 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / zak
1. We can define a primary key at the informatica level and configure session properties for Treat rows as "Update as Update" and check the Update check box.
2. If we shud not define the primary key at informatica level, then we can use Update override in Target properties. But i m not very sure of this. Kindly let me know
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
Tell me about Propagate functions in informatica
where to store informatica rejected data? How to extract the informatica rejected data?
What is parallel processing in informatica?
What is a pre-defined event and user-defined event?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
Can we create a Integration service without a Repository service and vice versa?
What is main use of mapplet?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is Cognos script editor?
explan ur project architecture?
How to implement security measures using repository manager?
What is mapping debugger?
Explain the use of aggregator cache file?
Difference between Data and Index Caches?
What is lookup change?
