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
AishwariyaV's avatar
AishwariyaV
Helper IV
7 years ago

The problem is, the dataset which I have has more than 10000 tables.

When Previewing, it is showing only 10000 tables.

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.