Interested to Buy Any Domain ? << Click Here >> for more details...
Can we insert ,update ,delete in target tables with one
update strategy tran.?
- 2 Answers
- 11307 Views
- Zensar, I also Faced
- E-Mail Answers
Answer Posted / manojkumar
Yes we can do all these insert,update,delete also reject by
using single update strategy.
In update strategy write the code like this
iif(somexvalue=xx,dd_insert,iif(somexvalue=yy,dd_update,iif
(somexvalue=zz,dd_delete,dd_reject)))
| Is This Answer Correct ? | 12 Yes | 2 No |
Post New Answer View All Answers
How many input parameters can exist in an unconnected lookup?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What do you mean incremental aggregation?
What is the function of aggregator transformation?
server hot-ws270 is connect to Repository B. What does it mean?
what is size of u r database?
Please let me know how to make Data masking in informatica..
What is meant by pre and post session shell command?
What are the different options available for update strategy?
What is update strategy transform?
Clarify the utilization of aggregator cache record?
Clarify the aggregator change?
What are the types of data warehouses?
How do you take back up of repository?
