How do I clear a table in TOS before transferring data into it?

[Anonymous]

Hello everyone, 

I am using TOS for Data Integration for transferring my data from data source to data warehouse, both on PostgreSQL databases. 

Before I transfer my data, I want to empty data warehouse table. How can I achieve this?

Thanks!

[Anonymous]

@lli 

Thanks for the correction 🙂 I overlooked that part.

My sincere apologies.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

Do not worry, you are not alone. Most of the developers - including some Talend guys - have not learned about the 3 parts of a component:

begin (B), main (M) and end (E) part.

Imagine a job with 3 components - just like your example. tFileInputDelimited_1 (name it component 1), tMap_1 (name it component 2) , tPostgresqlOutput_1 (name it component 3).

How the code will be looks like with their begin, main and end parts:

B3 > B2 > B1 > M1 > M2 > M3 > E1 > E2 > E3

I always complain, such information cannot be read in the Talend Wiki and is not part of any trainings!

[Anonymous]

@Harguna 

    We hope you have got the expected result for this post. Could you please mark the topic as closed by marking the posts which has helped to resolve your query?

    Its a great way to close the topic and it will help other community members also during their reference.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂