Dynamic Filename
Hi Folks
I have a problem with using dynamic filename as source in an ODI interface. I have read and followed the advice on other threads here for this, and the oracle blog (http://blogs.oracle.com/dataintegration/entry/using_parameters_in_odi_the_dy_1)
But I'm hitting a brick wall on this. . .
I have followed the following steps:
1. Created a Variable called myfilename
2. myfilename has refresh query (which works and runs ok on its own)
select 'ZVLU' || substr(TO_CHAR((SYSDATE + INTERVAL '-1' DAY),'yyyy/mm/dd'),3,2) || substr(TO_CHAR((SYSDATE + INTERVAL '-1' DAY),'yyyy/mm/dd'),6,2) || substr(TO_CHAR(LAST_DAY((SYSDATE + INTERVAL '-1' DAY))),1,2) FROM dual
3. On my source datastore I have set the Resource name to #MYPROJECTCODE.myfilename (MYPROJECTCODE has been verified as my project code)
4. Created a package with 3 steps. a - Declares myfilename, b - refreshes myfilename, c - interface to move data from 'myfilename' at source to A N Other file in target (I have separately verified that interface runs OK - with hardcoding etc)
5. Generate scenario from package.
6. Run Scenario
When I execute the scenario the filename is not being build dynamically.
The refresh variable resolves correctly to ZVLU110531 (my source filename)
However in the Load Step of the LKM, the source filname is not being dynamically built when <%=odiRef.getFrom()%> is referenced.
Here is what it resolves to . . .
MYSCHEMA.#MYPROJECTCODE."myfilename"
So, even though the variable has been seen to refresh to correct result, the Load step is not picking up the contents of the variable - but the variable name itself.
Any help appreciated.