In this post, It discussed about on automation of loading excel file in odi 11g..I am trying to load excel file into table by creating a DSN for the file and using this DSN name into my Excel topology data server.now my file name is changing on monthly basis and for that again i have to create a new DSN and then again reverse engineer the file. can anybody suggest me how to automate this process of loading excel data into table using Microsoft Excel Technology in ODI 11g.
To see solution for this, follow the below link..
To see solution for this, follow the below link..
https://community.oracle.com/thread/3869731?tstart=0
No comments:
Post a Comment