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 can we store previous session logs?
What is workflow? What are the components of workflow manager?
What are the different types of olap? Give an example?
What happens when a session fails and you click on recover?
Performance tuning in UNIX for informatica mappings?
What do you understand by term role-playing dimension?
Enterprise data warehouse your projects phase by phase explain?
What is session task and command task?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What is a pre-defined event and user-defined event?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
how to load rows into fact table in data warehouse
What is the function of look up transformation?
How do you load only null records into target?
How to create or import flat file definition in to the warehouse designer?