ODIExperts.com

The blog for Oracle Data Integrator ( ODI )

January 19, 2010
by kdevendr
2 Comments

Categories: How to , Logic , ODI , Reports , Tips and Tricks

Single Post View


Variable Detail Query

This query provides all the detail of the Variables created under various project and their associated  default properties. SELECT DISTINCT CASE WHEN SNP_VAR.I_PROJECT IS NULL THEN ‘GLOBAL_VARIABLE’ ELSE SNP_PROJECT.PROJECT_NAME END AS PROJECT_NAME, SNP_VAR.VAR_NAME AS VARIABLE_NAME, CASE WHEN SNP_VAR.VAR_DATATYPE=’A’ THEN ‘ALPHANUMERIC’ … Continue reading

January 16, 2010
by kdevendr
4 Comments

Categories: How to , Logic , ODI , Reports , Tips and Tricks

Single Post View


Topology Connection Detail

This query provide  all the necessary connection detail   in  ODI Topology. SELECT DISTINCT SNP_TECHNO.TECHNO_NAME AS TECHNOLOGY, SNP_CONNECT.CON_NAME AS DATA_SERVER, SNP_PSCHEMA.EXT_NAME AS PHYSICAL_SCHEMA, SNP_PSCHEMA.SCHEMA_NAME AS SCHEMA_NAME, SNP_PSCHEMA.WSCHEMA_NAME AS WORK_SCHEMA, SNP_CONTEXT.CONTEXT_NAME AS CONTEXT_NAME, SNP_LSCHEMA.LSCHEMA_NAME AS LOGICAL_SCHEMA, SNP_CONNECT.JAVA_DRIVER AS DRIVER_INFO, SNP_MTXT_PART.TXT AS URL … Continue reading


© Copyright 2024 | All Rights Reserved


Creative Commons License


Scroll to Top