Interested to Buy Any Domain ? << Click Here >> for more details...
How to delete the data in the target table after loaded.
- 3 Answers
- 9071 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 |
Separate from an archive server and a powerhouse?
How can you increase the performance in joiner transformation?
I am hvaing SOURCE as 1000,null,null,null null,2000,null,null null,null,3000,null null,null,null,4000 Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out
without matching columns in two tables. how can you join
If the records doesnt satisfy the filter condition where will it go?
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?
have you developed documents in your project? and what documents we develop in realtime?
The Source coloumns are A,B,C with data row1- 10,20,30 row2- 40,50,60 row3-70,80,90 and so on. In the target I want one coloumn with the following data, Coloumn-X, row1-10,row2- 20,row3-30,row4-40,row5-50 and so on. How to achieve this?
what is the complex transformation you used in informatica
What are the different threads in DTM process?
Which version configuration tool used in ur project?
What is sequence generator transformation in informatica?
Teradata 
