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
Enlist some properties of sessions.
What do think which one is the better joiner or look up?
What is DR strategy for Informatica project?
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?
How do you convert single row from source into three rows into target?
What is status code in informatica?
is it possible to index the data in cache of lkp transformation ?
What does reusable transformation mean?
What is fact table? Explain the different kinds of facts.
Repository user profiles
How to call shell scripts from informatica?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
Explain incremental aggregation in informatica
Name at least 5 different types of transformations used in mapping design and state the use of each.?