QVD store

[vijetas42]

Hi,

I have one database table where no. of rows are 223 million.in that I have 3 fields ID,class_nbr and roll_nbr

in this case i want to create two different qvd's with hitting db table only once.in first qvd it will store ID and class_nbr and in second ID and roll_nbr.

how to achieve this

[YoussefBelloum]

Hi,

just load ID and Class nbr on the first load followed by a STORE

then load ID and roll nbr on a second table followed by a second STORE

[atoz1158]

Hi

Assuming that the the load was into a table called "mytable" then use the following two store statements adjusting of course for your own names

STORE ID, class_nbr from mytable into firstqvd.qvd (qvd);

STORE ID, roll_nbr from mytable into secondqvbd.qvd (qvd);

Regards

Adrian

[balabhaskarqlik]

Connection string....

Table1:

Load

    [Store ID],

    Class_nbr;  or (Load *;)

SQL

Select

    [Store ID],

    Class_nbr from Table;     (Add conditions if required)

Store Table1 into Path\Table1.qvd(QVD);

NoConcatenate

Table2:

Load

    [Store ID],

    roll_nbr; or (Load *;)

SQL

Select

    [Store ID],

    roll_nbr from Table;   

Store Table2 into Path\Table2.qvd(QVD);