Run of DataFlow Times Out

I've got a dataflow that times out whenever I try to run it. The eror message says "Cache file timed out", and it looks to happen somewhere around 10-12M rows. I'm filtering one of the tables to reduce the number of records to process, but the time-out error occurs before it gets to the filter step. Any suggestions?

Best Answer

  • SLamba
    SLamba Member
    Answer ✓

    Thanks for replying, but I figured out a work around. I just switched the order of the tables in my join, and that sped things up.

Answers

  • kshah008
    kshah008 Contributor

    Hi all,


    Can anybody provide some insight for @SLamba?

    Thanks!

  • SLamba
    SLamba Member
    Answer ✓

    Thanks for replying, but I figured out a work around. I just switched the order of the tables in my join, and that sped things up.