what is recommended indexing rules for ETL in general?

0


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

 

 

rajneeshshukla's picture
Joined: Apr 6 2020 - 10:10am
Last seen: 4 months 3 weeks ago

0 Answers:

No answers yet
Feedback
randomness