Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey Guys,
Can we load just top 10 rows from database instead of the whole table . so that I can create QVD and thus the data model for time being.
Loading the whole table is taking time, which I can do later, right now my priority is to create data model.
Please help.
thanks in Advance
Hi,
Yes you can do this with different ways
1. Use First Key word put First 10 before the load statement
Ex:-
First 10
Load *
From SourceLocation;
2. And with Rowno() function you can also do this
Load *
From Source Where Rowno() <=10;
3. By the debug option in the edit script click Ctrl + E >> and then Debug >> and select limited load >> and select 10
By this you can load first 10 records.
Read the attached blog url also.
Regards
Anand
Thanks Gizzel123 for the question and Anand for the answer.
It's not my question so I won't mark it as 'Answered', but it is exactly what I was looking for.
You can do it even in sql select (according to the SQL) with mysql you can use Limit keyword, with MSSQL you can use TOP keyword, each DB has its own keyword.
hope it helps
Hi, also, in script you can clic on 'Debug', check 'Limited load' and set the rows to load for each table.
Good suggestion. I would normally do the TOP # in t-SQL - but in my case, I was doing a read from an inline table so used your first suggestion.