Mar-20-2021, 11:06 AM
Dear, I am trying to read a dw table (Teradata) and write to dw (Oracle), I made the connections, I am in doubt of how to do this process.
Select data between DW
|
Select data between DW
|
|
Mar-20-2021, 12:38 PM
what is dw?
If you can't explain it to a six year old, you don't understand it yourself, Albert Einstein
How to Ask Questions The Smart Way: link and another link Create MCV example Debug small programs
Mar-21-2021, 01:49 PM
Do a select on a table in the Teradata database and for each row returned do an insert in the Oracle database.
Optimization is possible by using "Batch execution" on the Oracle side. |
|
|
| Possibly Related Threads… | |||||
| Thread | Author | Replies | Views | Last Post | |
| SQL select join operation in python(Select.. join) | pradeepkumarbe | 1 | 2,906 |
Feb-14-2019, 08:34 PM Last Post: woooee |
|
| read select data from one file and write to another | Shameendra | 1 | 3,048 |
Oct-16-2018, 06:46 PM Last Post: ichabod801 |
|
| user input to select and print data from another class python | TyTheChosenOne | 6 | 6,570 |
Aug-30-2018, 05:53 PM Last Post: TyTheChosenOne |
|
| sql select data in row number | eml | 4 | 5,224 |
Mar-09-2018, 11:30 PM Last Post: Larz60+ |
|
| select Data input from csv file | SeanBassett | 6 | 6,016 |
Jan-21-2018, 10:06 PM Last Post: SeanBassett |
|
| problem with select and update the data into the database | chris0147 | 1 | 3,735 |
Aug-18-2017, 09:38 PM Last Post: chris0147 |
|
Users browsing this thread: 1 Guest(s)