Has anyone run PCA on biggish (~100M rows, ~100 columns) SQL table? Any strategies or pitfalls?
Another trick for datasets with high dimensionality is that you can randomly project the data to a lower dimensional space using random Gaussian vectors. By the Jordan-Lindenstrauss lemma, the projected dataset will have statistically similar properties under PCA.