Slowly Changing Dimension Stage - size limitations?
Posted: Wed Jan 23, 2013 9:05 am
I'm not in a position to test this directly and didn't have any luck with a search so I'll ask the question here:
Is there a 2Gb limit to the reference data to to SCD stage? Our source and reference data will be in excess of 5Gb but the documentation indicates an in-memory table is built which makes me think along the lines of the lookup stage and it's inherent memory limit.
Does anyone know for certain that this limit does, or does not, exist?
Is there a 2Gb limit to the reference data to to SCD stage? Our source and reference data will be in excess of 5Gb but the documentation indicates an in-memory table is built which makes me think along the lines of the lookup stage and it's inherent memory limit.
Does anyone know for certain that this limit does, or does not, exist?