Interested to Buy Any Domain ? << Click Here >> for more details...
How to delete the data in the target table after loaded.
- 3 Answers
- 9326 Views
- TCS, I also Faced
- E-Mail Answers
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 the use of source qualifier?
How to do Integration testing in Informatica?
Is it possible to define a single node as a Gateway node as well as worker node?
What is the benefit of session partitioning?
In a scenario I want to change the dimensions of a table and normalize the denomralized table which transformation can I use?
What is the meaning of up gradation of repository?
What are batches?
i have 2 mapings for this 2 mapings i want use only one lookupt/r how?
What do think which one is the better joiner or look up?
Design a mapping to load the cumulative sum of salaries of employees into target table?
what is the logic will you implement to laod the data in to one factv from 'n' number of dimension?
Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is loaded first Fact Table or Dimensions Table into the warehouse? What is the size of the Fact Table and Dimension Table? what is the size of the table and warehouse
Teradata 
