ODIExperts.com

The blog for Oracle Data Integrator ( ODI )

July 30, 2010
by kdevendr
6 Comments

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

Tags: , , , , ,

Single Post View


Error Records Log

Hi every one… In the last few posts we have shown how to display the SQL results in Operator , fetch the failed objects errors message in Package and various other techniques. Today we want to cover another small scripts … Continue reading

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 19, 2010
by kdevendr
16 Comments

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

Single Post View


Interface Mapping Query

This query will show the interface  mapping  in the following order PROJECT_NAME  , FOLDER_NAME  ,  INTERFACE_NAME  , INTERFACE_TYPE , TARGET_SCHEMA , TARGET_TABLE , TARGET_COLUMN , TARGET_DATATYPE , SOURCE_SCHEMA , SOURCE_TABLE , SOURCE_COLUMN , SOURCE_DATATYPE , MAPPING  filtered by Interface , … Continue reading

January 16, 2010
by kdevendr
3 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 2018 | All Rights Reserved


Creative Commons License


Scroll to Top