Not able to load the qvds

[ferha_jafri]

Hello everyone,

I am facing an issue as i am not able to load the qvds when i am loading them i can see all the data fetched but the window stuck at the last table ,only one table qvd is loading if i load more than one same thing happend.

Thanks in advance

Ferha Jafri

[swuehl · Accepted solution]

Hard to say what the issue is.

Do the qvds share a lot of common field names, but are not identical in number and names of fields?

Then you maybe create a huge synthetic key, which may stall your computer.

If this is the case, you need to decide how you want to model your data, you can only load the fields necessary, rename fields on load (or use qualify statement), or concatenate the qvd data into a large fact table, or...

[sathishkumar_go]

Hi, Use Qualify * statement in the above of the 1st table. so that we will come to know what is the issue? means issue in your data modelling. Regards Sathish

[saumyashah90]

Yes use Qualify Statement

and before hand just see if there are too many synthetic key's getting formed will also lead to the same problem

Synthetic key gets formed when you get more than one common field from other tables you load.

[suniljain]

Can you post log file of that application ?.

[ferha_jafri]

Thanks everyone, the reason was that the data model has a large no. of common fields i renamed them an now i am able to load the qvds ,thanks again.

[ferha_jafri]

Thanks Swuehl you are correct now, everything seems fine.