You are not logged in.
Announcement
Unanswered posts
|
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » Delete Obsolete functionality in Postgres?
#1 2009-06-09 14:47:26
- pankaj_02
- New member
- Registered: 2009-06-09
- Posts: 2
Delete Obsolete functionality in Postgres?
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!
Offline
#2 2009-06-10 07:43:57
Re: Delete Obsolete functionality in Postgres?
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
Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!
Offline
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » Delete Obsolete functionality in Postgres?