refer fpr better understanding
I don't think he ask for loading from/to a flat file, he just asks where the metadata of the interface is stored.
It is not in a file, it's stored in the work repository which is actually a schema on a database (Oracle DB or another RDBMS). You should ask your DBA to have a read access.
ya thanks..i got a read access DEV_ODI_REPO schema. But in that i can only see tables..how to know which 1 is my interface
Interfaces are mainly stored in the SNP_POP table.
You'll find your filters (and joins I guess) in SNP_POP_CLAUSE.
The mappings are in SNP_POP_COL and I think you can also find useful information in SNP_TXT_CROSSR.
Hope it helps.
Look into the SNP_POP table1 person found this helpful
ya i got thanks all for good response
Please mark the question as solved.