Forum Discussion
Append "mecanism"
a user told something weird, i'd like to have your feeling
Usecase : appending two tables
I thought the process would be like :
- import table 1 [15 min] *** fictive durations***
- import table 2 [15 min]
- append both tables [< 1 min]
But i've been told that the append process take a long time like if :
- import table 1 [15 min]
- import table 2 [15 min]
- append both tables [15 min + 15 min]
Would you confirm scenario 1 or 2 ?
Thanks
Steph
Hello Anonymous
the queries tab1 and tab2 should no be imported in your data model, so they are not loaded nowhere. But as you are refering to both of them in your combine-query they are loaded. I think that if loading 1 single tab takes 15 min, the append process will take almost that time x 2
BR
Jimmy
5 Replies
- manikumar34
Solution Sage
Anonymous ,
Not sure on this but you can try something like this.
If you don't need to load the tables, then you can append as new table or you can append Table 1 with Table 2 and disable the load on Table 2. So that your refreshing time will be quicker and Data size will be lesser.
regards,
Manikumar
Thanks Manikumar,
if i unactivate the load, it'd still import the data and it wouldn't go down into my model.
So my question would still be :
-import tab1 [15 min] and don't load into the model
-import tab2 [15 min] and don't load into the model
- append <1min or 30 min ?
I could deactivate the actualisation but i do want my data to be refreshed.
Jimmy801Community Champion
Hello Anonymous
the queries tab1 and tab2 should no be imported in your data model, so they are not loaded nowhere. But as you are refering to both of them in your combine-query they are loaded. I think that if loading 1 single tab takes 15 min, the append process will take almost that time x 2
BR
Jimmy
