Tuesday, September 14, 2021

Oracle Data Integrator all in one page links

12c ODI links below:

  1. ODI 12c Introduction
  2. Overview of Oracle Data Integrator Topology components
  3. ODI - how to add data servers and schemas in Topology
  4. Creating and using data models and datastores
  5. Creating the master work repository schema
  6. ODI type1 ODI 12c installation steps
  7. ODI type2 quickstart installation with virtual box
  8. ODI file reading steps
  9. odi-knowledge-module
  10. ODI mapping hardcode data and use case when with exppression
  11. ODI - MobaXterm and Connect to private subnet from jumphost
  12. ODI - Create scenario under package
  13. ODI - Types of variables and its uses
  14. odi-define-variable-and-use-in-package
  15. ODI - Create a date variable using sysdate and use it in a package
  16. ODI - Lookup component
  17. odi-join-and-filter-components
  18. ODI - about load plans
  19. ODI - ELT vs ETL
  20. ODI - agents
  21. ODI - distinct component
  22. ODI - Use of sequence object in surrogate key
  23. ODI - split component
  24. ODI - aggregate component
  25. ODI - Sets union operation
  26. ODI - Join component
  27. ODI - Sort component
  28. ODI static vs flow control
  29. ODI - staging area and different temporary tables
  30. ODI - subquery filter component
  31. ODI - expression component
  32. ODI - Reusable mappings
  33. ODI - Datafile check used and allowed max size
  34. ODI - steps to increase overall adw size.
  35. odi-12c-stop-and-start-odi-instance from oci console
  36. odi-12c-scheduled-jobs-and-load-plans ran twice issue
  37. odi-changing-odi-schedule
  38. odi-steps-to-restart-odi-agent
  39. odi-sql-query-to-monitor-temp-size
  40. odi-11g-and-12c-architecture
  41. odi-12c-standalone-and-j2ee-agent
  42. odi-12c-ckm-with-flow-control-nd-static control and recycle errors
  43. odi-12c-cdc-implementation-using-jkm
  44. odi-12c-manually-run-load-plan
  45. odi-12c-procedure-and-options
  46. odi-12c-database-free-space-check-sql
  47. odi-activate-or-deactivate-your schedule on load plan
  48. odi-12c-loading-flat-file-to-sql-table
  49. odi-12c-loading-xml-file-to-sql-table
  50. odi-12c-use-unique-temporary-object-name
  51. odi-import-ootb-knowledge-modules
  52. odi-12c-model-creations-with-constraints
  53. odi-12c-scheduling-odi-load-plans
  54. odi-create-model-and-topology-objects using wizard
  55. odi-move-file-using-odifilemove-command
  56. odi-security-component
  57. odi-oracle-12c-database-installation
  58. ODI - Import and export
  59. odi-topology-steps-and-model-creations
  60. ODI- how to track load plan step package scenario behind code from session id
  61. odi-db-query-to-check-sessions-status
  62. ODI read fixed length file and insert or append to database
  63. ODI read a CSV file and insert to database
  64. odi ikm oracle incremental update vs IKM SQL control append
  65. ODI - Why ODI has two J$ views with CDC and Journalizing
  66. ODI 12C - Write file names from OS location to database
  67. ODI 12C - Importing flat file to ODI studio
  68. ODI 12c - Read Multiple files and store them in database table
  69. ODI12c - Why the set variable increment paremeter is disbaled in package?
  70. ODI12C - How to open ODI studio from console or terminal
  71. Odi 12c - How to clean cache to start odi studio from console
  72. ODI 12c - Buffer too small for CLOB to CHAR or BLOB to RAW conversion

No comments:

Post a Comment

Featured Post

11g to 12c OSB projects migration points

1. Export 11g OSB code and import in 12c Jdeveloper. Steps to import OSB project in Jdeveloper:   File⇾Import⇾Service Bus Resources⇾ Se...