This discussion is archived
8 Replies Latest reply: Dec 19, 2012 4:51 AM by huny RSS

Dynamically creating file using variable

huny Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points