Infor ETL Indexes

Hi,

Is there an additional index on our staging (landing) tables that we should be implementing when we create the ETL target tables? I thought there was with the initial release of the tool, but maybe the tool is using the one that is created automatically.

Tina

Find more posts tagged with

Infor Data Fabric

Accepted answers

All comments

unknown

When generating a "create table statement" in the Transformation write step, a unique key "create index" statement is also generated.
If you need another index, write and implement a separate create index statement.
Does this answer your question?

unknown

Hola,

La estructura SQL de la tabla y el índice único que controla la integridad, se genera mediante el componente stagingupsert, pero un índice que nos dice el manual de información sobre ION ETL, es que también debemos crear un índice NO único para el campo dldocumentdate, Si necesitas ayuda sobre cómo usar la herramienta déjame tu correo, te enviaré manuales que hice en la fase de investigación e implementación de la ION ETL.

Copyright © 2025 Infor. All rights reserved.