Member since
07-17-2024
4
Posts
0
Kudos Received
0
Solutions
08-16-2024
07:48 AM
Good morning everyone, I need an idea to solve a problem. I'm searching for data in a source database and I need to do the incremental and differential and then save it in a table that is in another database. However, at first I carried out tests (image below) transferring data to tables that are in the same database. In this way, everything went well. However, now I want to do it between different banks. Would you have any suggestions? In the UpdateAttribute processor I do a merge. and in ExecuteSQL I execute ${sql.merge.query} @SAMSAL, @bbahamondes @haridjh Hi! Do you have any insights here? Thanks!
... View more
Labels:
- Labels:
-
Apache NiFi
08-09-2024
12:33 PM
I did as suggested by colleague @SAMSAL. I saved column by column, until I discovered that I had corrupted data. I had a data where the year was like "1111". As I had little experience, it was difficult to spot possible errors. Thank you everyone, especially my colleague @dianaDianaTorres
... View more