Incremental load override sorce and as well QVD, not able to concatenate

[Anonymous]

Hi,

I have a data file which is fact table data and is override daily. So, even my QVD also being override with data and not able to find my historical data in that QVD. It should concatenate old data with new data.

Give me any clue. or sample file.

Regards,

Kumar

[Anonymous]

You took two different source file names. But it should be same, because in daily load the file will come with the same name.

In script you have loaded one QVD and if you try to load the script it will search for that QVD and get fail?

In second file can you take different data and can you try to load.

[Anonymous]

Hi Varsha,

We should not use binary load.

[Anonymous]

Hi,

can anyone share some knowledge on this.

[settu_periasamy]

Can you explain your issue?

As already mentioned. . Load your existing qvd (already stored) and concatenate your excel file..

[Anonymous]

You have shared with me QVW file, in that three tabs are Main, Exit Script and Initial Script. In Main tab you have loaded QVD and ten concatenated excel file. So if you reload it will check QVD right?

[settu_periasamy]

yes

[Anonymous]

It will fail, because there is no QVD when I run first time.

[settu_periasamy]

First time, you need to run the Initial Script (one time process)

[Anonymous]

the script has to be scheduled very first run.

[Anonymous]

anybody is having any new thoughts.