Hello,
Is it possible inx DI to use the oracle function Connect by level?
I would like from a character string separated by “; in my source file, do an online conversion.
My query in the SQL editor is:
SELECT distinct RUID, trim(regexp_substr(TYPE_CODE, '[^;]+', 1, LEVEL)) FROM TMP_TEST_TYPE CONNECT BY LEVEL <= regexp_count(TYPE_CODE, ';')+1
You can use a Metadata Query for your use case :
You can directly pur your select query in a Query Metadata : create and use a metadata query. This Query Metadata will then be usable in a mapping as a source datastore.
Audric FREY
Hello,
Is it possible inx DI to use the oracle function Connect by level?
I would like from a character string separated by “; in my source file, do an online conversion.
My query in the SQL editor is:
Hello,
You can use a Metadata Query for your use case :
- Oldest First
- Popular
- Newest First
Sorted by Newest FirstTsiky RABARIJAONA
You can directly pur your select query in a Query Metadata : create and use a metadata query. This Query Metadata will then be usable in a mapping as a source datastore.
Audric FREY
Hello,
You can use a Metadata Query for your use case :
-
File external resolver with encrypted value
-
Timeout on Mapping/Webservice call
-
UNIQUE TEMP TABLE NAMES
-
Previous step name from a sub-process of execute delivery
-
Dropping multiple tables at once in XDI
-
Freeze Designer and corrupted workspace
-
FileWait/Move/Copy: FileInclude with space
-
Loop excel files
-
Change SVN user in the Designer
-
How to Specify the JVM used by the Designer?
See all 63 topics