Infor ETL Tool

Hi,

I have two questions

1) With the recent releases to the Infor ETL tool, since we have the tool installed locally (I believe), how do we get the most recent upgrades to the tool.

2) I want to only select records from MITTRA with a type of 31 to minimize the number of records we are pulling out of the data lake. Do i do this with the QueryAllcsv?

3) Do we need to go into our existing transformations to modify the query from dlDocumentDate to the new column?

Thanks All

Tina

Find more posts tagged with

Infor Data Fabric

Accepted answers

Kevin Heiman

1. You can download in ION Desk under downloads

2. We recommend using QueryAll for transformations. We do not recommend filtering the data but rather doing so in your data warehouse. Moving data via QueryAll is the most efficient method.

3. If you are on the latest, simply reactivating the transformation will source the new indexed timestamp to the output mapped column.

These and other questions / recommendations are covered in the Community article and video.

All comments

Kevin Heiman

1. You can download in ION Desk under downloads

2. We recommend using QueryAll for transformations. We do not recommend filtering the data but rather doing so in your data warehouse. Moving data via QueryAll is the most efficient method.

3. If you are on the latest, simply reactivating the transformation will source the new indexed timestamp to the output mapped column.

These and other questions / recommendations are covered in the Community article and video.

tdouglass

Thanks. Unfortunately, the table is MITTRA and that is ALOT of records that we don't need Is there any way to create like a 'view' of only 31's and use that as the data lake table source?

tdouglass

Hi Kevin.

When you say reactivate, what do you mean? This is what i have right now. How do i 'reactive' to get the new logic?

tdouglass

Ignore this question. I was able to look at the log to see that it is now using the index

unknown

Si necesitas ayuda sobre cómo usar la herramienta déjame tu correo, te enviaré manuales que hice en mi fase de investigación e implementación de la ION ETL.

Copyright © 2025 Infor. All rights reserved.