Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sivaprasad
Update strategy defines the sources to be flagged for
insert, update,
delete, and reject at the targets.
What are update strategy constants?
DD_INSERT,0 DD_UPDATE,1 DD_DELETE,2
DD_REJECT,3
If DD_UPDATE is defined in update strategy and Treat source
rows as INSERT in Session . What happens?
Hints: If in Session anything other than DATA DRIVEN is
mentions then Update strategy in the mapping is ignored
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
How can we use mapping variables in informatica?
What are the transformations that are not supported in mapplet?
How you prepared reports for OLAP?
State the limitations where we cannot use joiner in the mapping pipeline?
What is the function of union transformation?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What is meant by query override?
Write the different tools in the workflow manager?
Which development components of informatica have the highest usage?
explain abt ur project architecture?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Is there any way to read the ms excel datas directly into informatica?
