Forum Discussion
stanislav_dugas
Helper III
5 years agoAppend Querry DB2 and Txt File not working
Hi Guys, I have a problem. I am trying to append 2 querries one has as a source a DB2 connection and another txt.file. When i had this query settup that both had source as txt file there was no ...
- 5 years ago
Hi Icey thank you for your idea I was able to bypass the issue since it was all about performance. By adding the DB2 source, the performance of loading time for the data deteriorated quite significantly. So What I did was that I refreshed the model before the data entered the DB2 and appended query with .txt.
Since it had 0 rows on DB2 the appending worked fine and then I moved the model to reporting server which has much higher computing power then my Laptop and scheduled a refresh there with the full DB2 data. Now it is working fine as the update is happening on the server.
stanislav_dugas
Helper III
5 years agoThis is how the loading looks like: