Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI ,
I need to load daily lakhs of records in redshift.so i need to insert or update the data.by using tredshiftbulkoutputexec we can do insert operation only.by if i used tredshiftoutput for 1 lakh records it takes more than 6 hours.
is there any way to update ?
can any one help me ?
Thank you
lakhs of records
When You use a local terms, ожидайте неожиданного ответа
but in any case:
- bulk insert into stage table
- INSERT FROM SELECT WHERE NOT EXISTS
- UPDATE WHERE EXISTS
it also will be hard operation, but much faster than remote INSERT/UPDATE
lakhs of records
When You use a local terms, ожидайте неожиданного ответа
but in any case:
- bulk insert into stage table
- INSERT FROM SELECT WHERE NOT EXISTS
- UPDATE WHERE EXISTS
it also will be hard operation, but much faster than remote INSERT/UPDATE
How we can use tredshiftrow if the insert/update has to be made from postgres source data.
for example tpostgresinput --> tmap -->tredhsifptoutput?
How we can use tredshiftrow if the insert/update has to be made from postgres source data.
for example tpostgresinput --> tmap -->tredhsifptoutput?
Did we have solution for the below.
Did we have solution for the below.