Forum Discussion

DataGuy2016's avatar
DataGuy2016
Advocate IV
9 years ago
Solved

Stop Data Validation when merging tables

Hi Folks,

 

I am extracting data from Teradata and it is a very time consuming download, taking around 8 hours.

 

Everytime I perform a table merge, BI goes back to the source data and validates it all again.  This appears unnecessary and is threatening my delivery.

 

Is there any way to stop the data validation step when merging tables please?

 

Thanks

 

Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    DataGuy2016

     

    Currently, it's not possible to stop the data validation when doing sturcture change on dataset. If those tables you want to merge are from same database, you can consider using Direct Query mode it will not reopen connection to source database.

     

    Regards,

1 Reply

  • v-sihou-msft's avatar
    v-sihou-msft
    Microsoft Employee
    9 years ago

    DataGuy2016

     

    Currently, it's not possible to stop the data validation when doing sturcture change on dataset. If those tables you want to merge are from same database, you can consider using Direct Query mode it will not reopen connection to source database.

     

    Regards,