356 questions
0
votes
0
answers
66
views
How do I refresh a variable in an ODI's load plan?
I have a load plan in ODI 12c that executes 3 scenarios in an order. These 3 scenarios fetch data from tables in STG schema then load it into tables in STG_HIST schema, and all 3 scenarios use the ...
- 9
1
vote
1
answer
103
views
How to prevent duplicates when inserting into target tables with ODI 12c?
I was practicing ODI 12c and I came across this problem:
I have a mapping in ODI 12c that inserts the data from a staging table into a staging history table. The logical diagram is:
source: staging ...
- 9
0
votes
0
answers
30
views
Plsql block output to ODI variable
I have a plsql block which I am trying to execute in ODI stored procedure.
DECLARE
v_time_cols VARCHAR2(100) := 'DATA_REFRESH_TIME, UPDATE_DT';
v_sql VARCHAR2(1000);
v_result ...
0
votes
0
answers
41
views
ODI Metadata Repository - Getting Reusable Mappings used by Mappings
I need to extract from the Oracle Data Integrator Repository the Reusable Mappings used by Mappings.
We know there's the SNP_MAPPING table, which contains all Reusable Mappings and Mappings.
For ...
0
votes
0
answers
21
views
ROLLUP usage in Oracle Data Integrator (ODI)
I have an insert statement like;
INSERT INTO table
(column1, column2, column3 )
SELECT fact_1_id,
fact_2_id,
SUM(sales_value) AS sales_value
FROM dimension_tab
GROUP BY ROLLUP (...
- 111
0
votes
0
answers
56
views
ODI studio command line interface to import ODI xml scenario file and execute. How to do it?
I have ODI Studio installed and the ODI agent configured. We have a test environment where an ODI XML scenario has been exported. Now, we need to import and execute the same exported XML scenario in ...
- 11
0
votes
0
answers
31
views
doStandardReverse only for some tables that don't exists in the Model
I am trying to use doStandardReverse using ODI SDK Groovy only for some tables that do not exist in the model.
I found the datastore created, but without attributes.
If I manually reverseengineer a ...
-1
votes
1
answer
49
views
How to add multiple emails in vbcs object trigger?
How to add multiple email to object trigger in visual builder cloud studio?
I can add single recipient or single variable. I need to add multiple email in a same email, so that i can see to whom are ...
1
vote
0
answers
445
views
ODI 12c Work Repository: Reusable Mapping Lineage
My team is trying to create a Data Lineage SQL query using the metadata tables from the ODI-12c work repository. The idea is to input a specific column into our query and return all the stages/...
- 11
0
votes
1
answer
120
views
ODI 12 (12c) mapping (Teradata-> MSSQL) Error
Hi, I'm stumped, the problem is this:
I’m testing work on a new server - I took the FDMEE repository as a basis and decided to add ODI scripts to it (how do you feel about such cohabitation?)
...
- 23
0
votes
1
answer
96
views
How to add date_column when reading from a file in Oracle ODI
I want to read data from a .txt file in ODI and when mapping the source table to the target, add a date column representing the current date. Do you have any suggestion how I can do that?
- 65
0
votes
0
answers
127
views
Can I get the resource name of an aliased data source?
Since the actual name of the flat file diverged from the purpose,
I gave the data store an easy-to-understand name and the actual file name as the resource name.
Is it possible to get the resource ...
- 11
1
vote
1
answer
296
views
Finding the “Use Unique Temporary Objects Name” option in the ODI Repository
I would be interested to know how to find (on the ODI Metadata Repository) all Mappings that have this flag enabled on their Physical Design:
“Use Unique Temporary Object Names”
Does anyone know ...
1
vote
1
answer
173
views
How to run a simulation in Oracle ODI using Java APIs?
I want to interacti with Oracle Data Integrator 11g using the provided Java SDK.
I am able to connect to the ODI instance, but I do not know how to run a simulation from a selected intefrace.
Here is ...
- 13
0
votes
1
answer
738
views
Ho can I use Oracle ODI Variables in an ODI mapping
I am new to Oracle ODI, and I am learning it. I want to know how I can use the value of an ODI variable within a mapping. And also its reverse, that is, how to assign a value to a variable from within ...
- 319
0
votes
1
answer
357
views
ODI 12C. Compare two Numeric variables, get error
I'm using Oracle Data Integrator 12C. When I trying to use Evaluate Variables to compare two Numeric type variables I get error:
ODI-1233: Error while evaluating variable the following expression: COM....
- 57
1
vote
1
answer
432
views
ODI 12c Substitution API
I have a mapping where I use IKM Incremental Update.
In this mapping, the "Use Unique Temporary Object Name" option is checked Figure-1.
In IKM Incremental Update i added a new step and ...
- 11
1
vote
1
answer
2k
views
ODI 12 how to store a value in a variable or procedure option
At the procedure step in the ODI script, I use Jython, take the values from the tables I need - I get a string -> put it in VERSION -> I need to pass the VERSION value from the ...
- 23
0
votes
2
answers
2k
views
ODI Studio won't start on Windows 11 - tried multiple JDK versions and compatibility mode, any ideas?
I have installed ODI Studio (fmw_12.1.3.0.0_odi.jar) on a Windows 11, but I can't get it to start. It loads approximately 5% and then closes without displaying any error or log. However, there is no ...
1
vote
1
answer
607
views
Variable value assignment in Oracle Data Integrator
<?
String mystr = "#MY_ODI_VAR";
out.print(mystr);
?>
I want to assign value stored in an ODI variable (MY_ODI_VAR) to another variable (mystr) defined inside Java Code in a ...
- 51
0
votes
1
answer
267
views
Can I skip or inactive any ODI components from packages while executing in ODI 11g?
I would like to deactivate or skip or inactivate any one of a component in the ODI package while executing, without deleting the desired component in ODI 11g.
As i have some SMTP server issue, i ...
0
votes
2
answers
976
views
Generate header with OdiSqlUnload for a csv file
How do I generate header with OdiSqlUnload for a csv file?
At the moment I have this code but it does not generate the column headers ot the table.
OdiSqlUnload "-FILE=<%=odiRef.getSchemaName(&...
- 21
0
votes
1
answer
562
views
ODI 12c export and import objects using Java SDK
Hi I am trying to write a pure Java code that can run outside of odi studio to export and import specific objects like mapping variables procedures separately in to xml files.
Any help or code ...
- 1
0
votes
1
answer
367
views
ENC_KEY_LEN error while running the Queries Azure Databricks
I am facing below mentioned issue while running the queries on Azure Databricks using Oracle Data integrator , please help me resolve this issue.
*Caused By: java.sql.SQLException: [Databricks]...
- 59
0
votes
0
answers
93
views
How to select a certain number of random values with odi 12 c?
How can I make the following query work in odi 12c?
I need your support on which components I need to use and how.
SELECT *
FROM (
SELECT *
FROM table name
ORDER BY DBMS_RANDOM.RANDOM)
...
- 1
0
votes
0
answers
290
views
Unable to connect Oracle ODI Marketplace to mysql embedded repository
i'm starting using Oracle ODI Marketplace. I've just deployed an instance on a VM in Oracle Cloud, by choosing the solution with the embedded mysql repository.
Now the problem is that when i start ...
- 1
0
votes
1
answer
3k
views
Run python script oracle data integrator (ODI)
I am looking for help to be able to execute a python script on oracle data integrator (ODI)
I have not found any documentation for this process
I would appreciate if someone can help me with this ...
- 1
0
votes
1
answer
1k
views
ODI 12c Variables
I am facing difficulties in the doing the following task:
Create a table in db, which contains the file name.
Read the file name from this table using variable in ODI.
Read from this file and then map ...
0
votes
0
answers
648
views
Generate create table script for Oracle from SQL Server tables
We are working on migration project and need to create table script for Oracle from SQL Server tables.
Is there anyway we can automate the process of creating these SQL server tables in Oracle.
1
vote
1
answer
727
views
How to load data from text file to table in odi 12c mapping?
I am trying to load data from text file to a table. The mapping executes successfully but no data is loaded to the staging table. I am using LKM FILE TO SQL and SQL Control Append as IKM. Staging ...
- 23
0
votes
1
answer
329
views
How to extract Excel sheets into multiple CSVs then transform into .txt file on Oracle Data Integrator (ODI)?
I'm seeking experts' help to suggest/recommend a better workaround to my use case below, (ODI is very new to me btw):
Desired output: .txt files
Input: an excel file with multiple sheets
Input source:...
- 23
0
votes
1
answer
102
views
Empty value is giving wrong Value after being mapped
I have Three Tables all of them have a column called RECORD_TYPE which is present as empty records in the Source file.
Table 1:
|RECORD_TYPE|
----------
|('null') |
Table 2:
|RECORD_TYPE|
----------...
- 31
0
votes
1
answer
62
views
SQL Query generates duplicates
I'm currently developing an ETL process in ODI. The source file has the following shape:
| MPS_OPERATIVA | MPS_DETALLEOPERATIVA | RAM_ID | RAM_ALIAS | RAM_NOMBRE ...
- 213
0
votes
1
answer
671
views
ODI 12c CUSTOM_TEMPLATE extract option not working
I'm using the CUSTOM_TEMPLATE extract option on the source table to force a select actually from another table. Which then would be used by a custom IKM I'm using in order to get the column list of ...
- 1
0
votes
1
answer
2k
views
The following bind parameters (56:44.0) in the task command <MERGE QUERY> are not bound to any value
I have developed a package in ODI which has couple of variables and followed by the mapping, these variables are used inside the Mapping transformation when I run the scenario I am getting this error :...
- 55
0
votes
1
answer
200
views
Variable be assign or refresh Unicode characters garbled (ODI)
I have using Variables refresh text from MSSQL, but the return garbled characters that contains Chinese characters.
Running the same script in MSSQL returns the correct result without garbled.
Do you ...
- 1
0
votes
1
answer
178
views
Is there a way to handle fields with only spaces using ODI?
I have a json file with the following snippet
{
"brandName": "b1Name",
"brandDesc": "b1Desc",
"brandId": "75",
"...
- 1
1
vote
2
answers
949
views
ORA-30483: window functions are not allowed here in ODI Mapping
I am working on ODI mapping where I am calculating" Min(ID) over parition by(device_num, sys_id) as min_id" in expression component, I used another expression component to filter duplicates ...
- 55
0
votes
0
answers
1k
views
Oracle ODI 12c performance tuning how to add hint
In Oracle Data Integrator 12c I have a job that's selecting from quite few number of tables and writing to a file. As suggested by DBA he wanted me to add HINT at the begining of the select query ex:
...
1
vote
1
answer
3k
views
Difference between lookup and join in oracle data integrator
I have created the basic mapping in ODI but i dont understand difference beaten lookup and join.
user17104035
0
votes
1
answer
2k
views
Restarting ODI 12c load plan persistently goes to the else step of a case step
I have a load plan in ODI 12c which goes into error at an 'else' step.
The structure of this problematic part of the plan is:
SERIAL step
1.1. RUN SCENARIO for refreshing a variable
1.2. CASE step
...
- 1
0
votes
1
answer
2k
views
ODI 12c integration knowledge module merge when using reusable mapping
Is there away to use the integration knowledge model Merge when using reusable mapping?
I am able to use the Merge IKM when just using datastores but when I added a reusable mapping the option no ...
- 1
0
votes
2
answers
844
views
Delete Duplicate in I$ table in ODI
We have a load plan in ODI. We get a repeating error in some on our scenarios due to duplicate records in the I% table. What we do is manually run the script every time the load plan fails.
DELETE ...
- 63
0
votes
0
answers
822
views
ODI procedure for calling a stored procedure for delete doesn't work when started with the ODI agent
I have created a stored PL/SQL procedure on the DB which needs to delete rows with certain conditions. It is called by an ODI12c procedure, code is in the 'target code' section and is without any ...
- 1
1
vote
0
answers
411
views
How to delete unwanted records in the Target table in Oracle Data Integrator (ODI)
is there any method to delete unwanted rows in the Target table without truncating the Target table?
If any record is deleted in Source table, it will remain in Target table.
I am using IKM Oracle ...
- 317
1
vote
2
answers
2k
views
ODI 12c - No object could be dropped on the diagram possibly because the chosen technologies in the "Create As" dialog were incorrect
I am going to use reusable mapping in odi 12c, but there is a problem. When ever I drag and drop a table into the environment, it gives me this error:
No object could be dropped on the diagram ...
- 55
0
votes
0
answers
1k
views
Oracle Data Integrator Model not showing Tables after Reverse Engineering
I've created a model in ODI with a SQL Server datastore.
But after successful connection and reverse engineering, I can't see the tables in the SQL Server database.
I've tried adding tables, views and ...
0
votes
1
answer
568
views
How to insert default value in odi?
I Have a map with union component that execute every night with truncate target table.
I want to insert one row with -1 value then insert my data.
how can I do it?
thanks for your help.
P.S: I have 6 ...
- 19
0
votes
0
answers
704
views
ODI connection to Snowflake using JDBC driver
I followed all the steps mentioned for ODI to connect to Snowflake and I am able to connect 'without agent'
I also 'unset' the SSL/TLS parameter using code below but still ODI is not able to connect ...
- 11
-1
votes
1
answer
613
views
How to filter by column length in ODI?
I have a mapping in Oracle data integrator that works correctly, I need to filter by a column and exclude the rows where the length of that column equals 3. I can't find the correct function to do it. ...
