I have about 20 to 30 ODI Variables (VAR_COL1, VAR_COL2.....) that come from one database table and one record (COL1, COL2 ....)
Following 2 options are used in ODI Package and am looking for third option for Performance Reasons..
1. Traditional refresh, each variable is refreshed SELECT COL1 from table1; This makes 30 trips to database and creates 30 session tasks in ODI SNP_SESSION_TASK tables
2. Java Beanshell Refresh : with one database trip, 30 values are assigned to 30 Java Beanshell Variables using ODI PROC , Source and Target feature. This creates one session task.
Java Beanshell Variables, 30 values, are assigned to each ODI variable in ODI Package, This creates 30 Session Tasks in SNP tables
I am looking for third option. Is it possible to 'assign' all the 30 ODI variables in one session task from java beanshell variables