Talend community forum / Post a reply

Open Data SolutionsData Management solutionswarehouseOpen StudioBusinessExtract Transform LoadETL

You are not logged in.

Announcement

[2013-05-06] Boston Area User Group Meetup
[2013-05-02] NOTICE TO ALL TALENDFORGE USERS: maintenance completed
[2013-04-26] Talend Open Studio's 5.3.0 release is available
[2013-04-12] Ready for testing - Talend Open Studio's 5.3.0RC2 release is available
[2013-04-11] Talend’s corporate pages and groups on social media

Unanswered posts

Data mining solution by kzone
Access web user interface MDM impossible by olivierjurine
Not Able to fetch Complete Data using RegEx using tPatternExtract by yogeshballani
How to setup [...] by frankEichholz
null pointer exception on Edit Properties of [...] by wengem77
Running context with Tomcat by olivier.riche
disable Service Activity Monitoring (SAM) by vnodkmar

Index
» Usage, Operation
» Delete Obsolete functionality in Postgres?

Post a reply

Topic review (newest first)

shong: 2009-06-10 07:43:57

Hello
First, Are you sure you have deleted 1 rows in source table? If you select the 'delete' action, it will delete the rows from target table, which have the same key in source table.
Second, you can use a tOracleRow to execute a sql statement to delete rows.
Best regards

shong

pankaj_02: 2009-06-09 14:47:26

Hi,

I have migrated all the data from Oracle(Source Table) to Postgres( Target Table) and then i have deleted 1 row from Oracle(Source Table) and then I did 2 things

1) I have applied "INSERT OR UPDATE" action on table . But still it is giving me the deleted row in Postgres(Target Table).
2) I have applied the "DELETE" action on table . While doing this i am getting the deleted row rather than the rows which are left in Oracle.

How to get the left rows rather than deleted row?

**I dont have to apply "DROP AND CREATE"action on Target Table.

Kindly help me out.

Cheers!

Announcement

Unanswered posts

Post a reply

Topic review (newest first)

Board footer