Can we insert ,update ,delete in target tables with one
update strategy tran.?
Answer Posted / sehaj
WE CAN UPDATE INSERT ROWS INTO TARGET TABLE USING SAME
UPDATE STRATERGY IN A SESSION BUT WE NEED TO SELECT THE
OPTION UPDATE ELSE INSERT OPTION FROM SESSION
PROPERTIES>MAPPING.
BUT WE CAN INSERT UPDATE N DELETE,I MEAN PERFORM ALL THREE
AT A TIME.
| Is This Answer Correct ? | 2 Yes | 6 No |
Post New Answer View All Answers
How many transformations can be used in mapplets.
How to differentiate between the active and passive transformations?
What is the need for an etl tool?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
what is size of u r database?
What is the function of union transformation?
tell me about your project functionality
What do you mean by filter transformation?
what is SDLC way of code development?
Explain the types of lookup transformation?
explain abt ur project architecture?
What is the command used to run a batch?
What is joiner transformation?
Explain the types of transformations?
Explain the aggregator transformation?