We have an issue (we just went into product) where the select from a Data Lake Table does not match the data catalog layout. I am assuming these are new fields. But what drives the columns returned when we do a select *. It obviously is not the data catalog. Is it headers on the JSON files? What will happen when we repush…
Hi, Is posible to Purge a Object in Data lake before the next ingest load? The purge option in data lake is only Ad Hoc? Someone knows if is possible? Regards, Mauricio
Hello Greetings!. We are in the progress of setting up the connection configuration to call the ION API's, and third party provides Http Client, Rest Client. Can anyone please suggest what is the best practices. Thanks
I noticed a record count difference between a table I downloaded via ION ETL and the record count in Compass. By changing my compass query to included deleted records I was able to get the record count to match. I.E. SELECT COUNT(RepSet_Variation_ID) FROM infor.IncludeDeleted('FHDL_FSM_Actor') I tried to add a query string…
Consulta, estamos consumiendo datos mediante ION ETL, todo normal hasta ahí. Resulta que la zona horaria del Data Lake es UTC+0, pero yo me encuentro en UTC-5, por lo cual necesito establecer una configuración general para que los campos tipo fecha bajen con UTC-5 y no con UTC+0 como actualmente están bajando. O si conocen…
Hello, My team and I have been looking for ways to make sure the data coming through in the Data Lake accurately reflects what data there is on the front-facing side of the Infor application. We can do things like comparing Employee counts or sum of Hours, but we were wondering if there is another tool or method that can…
The following describes the new release highlights for users of Infor OS Data Fabric: * Compass Mode Configuration: Compass SQL architecture is enhanced to support a new query engine mode, called Analytical mode. The Compass Query Editor now includes a Mode Configuration panel. Compass Mode Configuration, enables users to…
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…
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
Where is the User and the Security Roles stored in the Data Lake? Audit and Monitoring Setting have Publish Auditing and Monitoring data to Data Lake checked.
It looks like you're new here. Sign in or register to get started.