Problem loading csv data into oracle table

[Anonymous]

I have an oracle table with 66531 rows of addresses with no postal codes and I have a csv file of 66531 rows of postal codes, I want to update the oracle table rows to have the postal codes from the csv file. I originally transferred the addresses from a SQL Server table or Oracle table is there a way i can also include the postal codes so they are added with the SQL Server table transfer?

This is what I have tried:

I am pretty sure it is trying to make new rows in the oracle table with just postal codes, how can I do it so it adds the postal codes to pre existing rows?

[Anonymous]

Hi
The postal code of each line in csv file should be added to the same line of row in Oracle? I don't see a foreign key in postal code rows.

Regards
Shong

[Anonymous]

Hi,

    It will be a risky proposition to update the postcode just based on row number of earlier data. You will need some other data like full address to match with incoming postcode data. If you do not have any other option to match with old data and new data, its better to standardize the data using a third party call (like using Google or Experian components in Talend) or you will have to refresh the full address again from source with postcode.

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]

I have an oracle table of 66531 rows of addresses that have null postal codes, I need to add postal codes to those rows from the csv file that I have that has 66531 postal codes - the data is just random postal codes, I am just supposed to add random postal code data to the oracle table addresses.

[Anonymous]

If I added a corresponding address_id column in the csv file to match the primary keys of the oracle table would I be able to connect the data by that way?

[Anonymous]

Yes, if the CSV file has the corresponding address_id column, you can do an inner join on tMap to map the postal code based on the address_id column, eg:
tOracleInput--main--tMap---out1--tOracleOutput
|lookup
tFileInputDelimited
on tMap, do an inner join based on address_id column.
on tOracleOutput: select update action in the Data action list, set address_id column as key on the schema.

Regards
Shong

[Anonymous]

I will try that out as soon as I can add address_id to the csv file thanks. Is there a way I can add a column to the csv file that auto increments to make the address_id?

[Anonymous]

Hi
You can read the CSV file, add a new column with integer type on tMap, call the built-in function to generate the sequence id , for example, write this code in the expression field of the new column.
Numeric.sequence("s1",1,1)
And output the data to a new CSV file.

Regards
Shong