Delete Target Table

1. Identify the Target Table
• The target table is specified by the variable <%=odiRef.getTable("L","INT_NAME","A")%>.
• This dynamic expression retrieves the name of the target table (likely through Oracle Data Integrator or a similar system).
2. Understand the Action
• The task involves running a DELETE SQL command to remove all data from the identified target table.
• The SQL query is structured as:

o   delete from <%=odiRef.getTable("L","INT_NAME","A")%>

• This query will delete all rows in the specified table.
2. Transaction Context
• The delete operation is executed in a transaction. However, it’s important to note that this transaction is not committed immediately.
• The deletion will only take place if the DELETE_ALL Knowledge Module (KM) option is selected.
3. Execution Conditions
• The DELETE_ALL Knowledge Module option needs to be selected to trigger this command. It’s part of a larger ETL (Extract, Transform, Load) process where, if this option is chosen, the data in the target table is deleted.
4. Data Deletion
• The DELETE command will remove all data from the target table but will not remove the table itself or its schema.
5. Commitment
• Since the operation is not committed by default, the changes (deletion of the rows) will be rolled back unless explicitly committed later in the process.