Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I have a QVD having 17 million records so I need to load only 1 million records from QVD.
Can any one tell me how to achieve this?
Thanks,
Chinnu.
Use First before load statement
Ex:-
First 10000
Load
*
From Source;
And for you solution First to be place on before load statement
First 1000000
Load
*
From Source;
Use First before load statement
Ex:-
First 10000
Load
*
From Source;
And for you solution First to be place on before load statement
First 1000000
Load
*
From Source;
May be this?
FIRST 1000000
Load * From Qvd;
Try like
First 1000000
Load *
From ABC ;
Or another way is
Load
*
From Source Where Rowno() <= 1000000;
OR By first key word also
First 1000000
Load
*
From Source;
Thanks Anand for your reply, It's working fine
Thanks,
Chinnu.
Thanks