How to delete the data in the target table after loaded.
Answers were Sorted based on User's Feedback
Answer / venky
write post sql in target table as truncate table tablename
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / honey
SQ---> Properties tab-->Post SQL
delete from target_tablename
SQL statments(s) executed using the source database
connection, after a pipeline is run
Is This Answer Correct ? | 6 Yes | 2 No |
we have the property in session truncate option.
Is This Answer Correct ? | 1 Yes | 10 No |
what is mean by flag 4 in update strategy t/r
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
what is polling?
How to use procedural logic inside infromatica?
What is the procedure for creating independent data marts from informatica 7.1?
can we see default group,when we use router?if yes how?
What is aggregate awareness?
What is router transformation
What is A complex mapping?
What is query panel?
How to do unit testing in informatica?