1 Reply Latest reply: Nov 16, 2012 1:33 AM by JeromeFr RSS

    How to Get the files Names in Repository??

    AMSI
      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
          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.