We have a below requirement for replicating data from file system to oracle database, its like , there is text file data , its needs to replicate to oracle database , can we use goldengate for this requirement, for replicating data from file to oracle?
Or, sql*loader? GoldenGate is kind of a big (and expensive) hammer for such a small nail. Fwiw, I've implemented a simple proof-of-concept loading files into GG before, so it can be done (hint: via GG JMS capture & some Java glue code...), but it's not the best tool in the toolbox for the task. See here for pointers to your other options: http://www.oracle.com/technetwork/database/enterprise-edition/index-093639.html (sql*loader, external tables)