what r d pre-requiste for update strategy transformation,
and differnce between delete n truncate in target session
properties for update strategy
Answer Posted / 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 |
Post New Answer View All Answers
What are the advantages of informatica?
What does update strategy mean, and what are the different option of it?
what is the size of u r source(like file or table)?
What's the layout of parameter file (what does a parameter file contain?)?
What are the different clients of powercenter?
What is fact table? Explain the different kinds of facts.
Differentiate between a repository server and a powerhouse?
What is update strategy transform?
How many transformations can be used in mapplets.
What is the difference between a connected look up and unconnected lookup?
Design a mapping to load the cumulative sum of salaries of employees into target table?
Explain what are the different types of transformation available in informatica.
What is transformation?
What is the format of informatica objects in a repository?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?