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 |
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What r the type of indexes u generally used in informatica?
How to write a procedure for a date which is in three different formats,and you want to load into datawarehouse in any single date formate
What happens if you increase commit intervals and also decrease commitExplain grouped cross tab?
surrogate keys usage in Oracle and Informatica?
5 Answers ITC Infotech, Oracle,
can we override a native sql query within informatica? Where do we do it? How do we do it?
how to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to target table
follwing scenario two table using find maximum salary? table a table b 101 xxx 1000 106 6500 103 yyy 5000 108 800 104 din 6000 109 7000 105 dsh 200 110 3000
what are the Methods For Creating Reusable Transformations?
What is the use of an aggregator cache file?
Explain the use of aggregator cache file?
If one flat file contains n number records., we have to load in target from 51 to 100.. how to use expressions in Informatica..?