354 questions
Advice
0
votes
1
replies
74
views
ODI Git VCS integration: file naming convention, Smart Export dependencies, and fallback to legacy versioning
I'm currently working on migrating our ODI environment to Git-based version control. I've been doing some research but couldn't find clear answers in the Oracle documentation, so I was hoping someone ...
0
votes
0
answers
52
views
Groovy SDK for ODI: Create and Map Logical Schema to Physical in Topology
In Oracle Data Integrator (ODI 12.2.1.4), I'm automating topology creation using Groovy SDK. I can create Data Servers and Physical Schemas, but stuck on creating Logical Schemas and mapping them to ...
- 43
1
vote
1
answer
127
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
47
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
54
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 ...
-1
votes
1
answer
52
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
501
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
139
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
100
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
143
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
331
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
186
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
830
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
372
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
461
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