In Topology, can a query be defined to retrieve native database sequences?
A.
Yes, in the technology details in the Topology submodule, there is a tab that defines queries for
specific database elements.
B.
Yes, but you need to specify an option in the knowledge modules of the mapping using
sequences.
C.
No, only the timestamp definition can be set in Topology.
D.
No, the query for nativesequencesis defined in ODI Data Models, under ODJ Studio Designer.
Explanation:
I think that is A
A.
One CAN define the sequence syntax on technology and physical schema levels. Ex : it’s “%SCHEMA.%OBJECT.nextval” for Oracle.
But I never found any use to it.