knowledgebase:making_etl_transformations_read_only

Making ETL Transformations Read Only

No one wants to be famous for a wrong reason, this is why it is important to prevent changes to ETL transformations once they are deployed to the production.

This can be easily done with the latest versions of Advanced ETL Processor and Visual Importer ETL.

All the user have to do is to press the read-only button.

It is also possible to make several objects read only by selecting the top node from the objects tree.

ALTER TABLE OBJECTS_TREE ADD READ_ONLY Integer NULL

ALTER TABLE OBJECTS_TREE ADD READ_ONLY decimal(28, 0) NULL

ALTER TABLE OBJECTS_TREE ADD READ_ONLY Numeric

ALTER TABLE OBJECTS_TREE ADD read_only double precision null

ALTER TABLE OBJECTS_TREE ADD READ_ONLY DOUBLE PRECISION NOT NULL

We would like to thank Orlando Cabrera from Xerox Canada Ltd for providing us with valuable feedback

For more technologies supported by our ETL Software see Advanced ETL Processor Versions and Visual Importer ETL Versions

Confused? Ask question on our ETL forum

  • knowledgebase/making_etl_transformations_read_only.txt
  • Last modified: 13/04/2019 17:24
  • by admin