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