•
Define indices to improve query performance. • Staging tables typically do not
require indices.
•
Create indices on all columns that the ETL uses for dimensions and facts. For
example:
–
ROW_WIDs of dimensions and facts – INTEGRATION_ID
–
DATASOURCE_NUM_ID
–
Flags
•
Carefully consider on which columns to put filter conditions.
•
Inspect preconfigured objects for guidance.
• Register indices in the appropriate ODI model..
No comments:
Post a Comment