Skip to Content
0
Apr 30, 2020 at 03:11 AM

what is recommended indexing rules for ETL in general?

41 Views Last edit May 06, 2020 at 09:07 AM 2 rev

Hello Experts,

What kind of indexes are recommended for staging area in ETL flow. For example unique index on natural key columns. I have surrogate key as well in data flowing in from source.

Also any suggestion/recommendation for indexing in other layers like dimensional data model layer and type 1 persistent data layer for full snapshot data.

Thanks, Rajneesh