Forum Discussion

AishwariyaV's avatar
AishwariyaV
Helper IV
7 years ago

loading only the needed tables from SQL Server

Hi all, Is there any way to make restrictions, so that I will be able to load ONLY the tables that is required, from the data source.  
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

With tables you mean records right? And that's normal, preview only shows a subset of your data. Once you load it, it should contain however many records you have.

AishwariyaV's avatar
AishwariyaV
Helper IV
7 years ago

Yeah, records. When I import dataset from SQL Server, the navigator shows only 10000 records. But i have more than that. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Once you physically import them, it'll be more than that figure. Try it. 

    Preview does literally what it says... give you a preview.

     

    In SQL terms it just does:

     

    Select top 100000 (*) from YourTable

     

    Importing it does:

     

    Select * from YourTable

     

    EDIT: If you're LITERALLY talking about having 100000 tables (and not records) then just import with a SQL statement instead of using the navigator.