This discussion is archived
1 Reply Latest reply: Nov 15, 2012 11:33 PM by JeromeFr RSS

How to Get the files Names in Repository??

AMSI Newbie
Currently Being Moderated
hi,
I am loading the Multiple files. All of these files name list is assign to variable. Problem is i want to get  the name of the files from the ODI Reporsitory. I mean to say can Reporsitory store the files name??? if it store then in which table??

Regards,
AMSII
  • 1. Re: How to Get the files Names in Repository??
    JeromeFr Expert
    Currently Being Moderated
    It is only stored if you keep history for all values for your variable.
    SELECT * FROM SNP_VAR_DATA WHERE VAR_NAME = 'YOUR_VARIABLE' ORDER BY FIRST_DATE DESC;


    However I recommend you to store the filenames in a table yourself at loading time. I explained you how to do that in this thread : how to Load file name in to Oracle table column


    Hope it helps.


    Kind Regards,

    Jerome


    PS : If you found answers helpfull / correct, please flag it (on the right of the answers). It ensure that contributers are awarded the points they deserve and that future readers will find the right answer directly.

Legend

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