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 |
If we are using an aggregator but forget to mention the group by port .what will be the output??
How to implement security measures using repository manager?
explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???
which T/r we can use it mapping parmeter and mapping variable? and which one is reusable for any mapping mapping parmeter or mapping varibale?
When we enable pushdown optimization technique, two options will be enabled (use view,..). Can anyone tell me how these two options will work ? When do we need to go for pushdown optimization technique ?
Could any one to tell Fact table Partitioning?
What are the performance considerations when working with aggregator transformation?
In incremental loading using Mapping variable if session failed with any of reason in the middle of process. is the Mapping variable remains constant or change?
what type of transformation is not supported by mapplets?
Whats the difference between $, $$, $$$
how may sources can be used in a mapping at a time?(limit)
explain different levels in pushdown optimization with example?