This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We are downloading tables using an OleDB connection and read-uncommitted. It seems that during the read Alteryx is producing duplicates, after analysis I am nearly 100% sure this is because of uncommitted reads. I have read a stack-overflow article that suggests it might be creating duplicates when a page split occurs (see link below). The post suggests SQL SNAPSHOTs as a solution but this isn't viable for us as it will greatly affect performance.