HI, i am facing an issue in creating file on run time using variable.
i have a variable FileName. In refresh tab i have written a query like SELECT TO_CHAR(SYSDATE,'YYYY,MM,DD') || 'TEST' FROM DUAL. i tested the variable and its value is correct.
i have created an interface to extract the data from table and store it in file. i have assigned variable FileName to the file.
Now when i run the interface...the file is created but the header is created in different file and its name is ambiguous e,g(19) and the data is placed in other file with the name which is the value of variable FileName.....
ISSUE is two ODI creates two files one for header only and other for data....
when i run my interface in a package the file created perfectly ..... but i dun want to use package i want to create file through running interface only
yes i use the variable in resource field.... i will be refreshing variable in a package separately before running my interface..... i do not understand why running interface creates two files ,one for header and one for data
one file name is some number like 19.txt and other filename is 20121211_TEST.txt (this name is coming from variable).....
however when i create a package with variable and interface,only one file is created 20121211_TEST.txt (header and data are not created in separate files.)
create header (ID,
Edited by: 975356 on Dec 11, 2012 10:57 PM
Edited by: 975356 on Dec 11, 2012 10:58 PM
history value is correct.
it seems that interface doesnt evaluate variable and create a dummy file.
i have created a package with an interface and variable in refresh mode.It is now working fine...
thnx all for your support