Results 1 to 5 of 5

Thread: Load data from oracle to Excel

  1. #1
    Junior Member
    Join Date
    Nov 2006
    Answers
    2

    Load data from oracle to Excel

    HI All,

    I want to load data from oracle to Excel. Could someone help me in this first we need to find out whether its possible or not because excel to oracle is possible but vice versa i dont know.

    If someone know how to load data from oracle to execl please let me know


  2. #2
    Junior Member
    Join Date
    Feb 2007
    Answers
    2

    Re: Load data from oracle to Excel

    it is possible to load data from oracle to excel and vice versa.
    i have done it myself.
    pls be elaborate on ur qus so that i can help u further


  3. #3
    Junior Member
    Join Date
    Nov 2006
    Answers
    2

    Re: Load data from oracle to Excel

    Hi,

    I am using informatica 7 and reuirement is we need to extract data from oracle and load into Excel.Hw can we achieve that in Informatica 7 instead of informatica 8.Is it possible.

    Vishal



    Quote Originally Posted by Rdivya View Post
    it is possible to load data from oracle to excel and vice versa.
    i have done it myself.
    pls be elaborate on ur qus so that i can help u further



  4. #4
    Junior Member
    Join Date
    Feb 2007
    Answers
    2

    Re: Load data from oracle to Excel

    Yes it is possible to do it in informatica 7


  5. #5
    Junior Member
    Join Date
    Aug 2010
    Answers
    1

    Re: Load data from oracle to Excel

    Hi Rdivya

    Can you please tell me how we can load from excel using informatica?
    So far i was able to import the tables into my designer and complete the mapping but when i try to run the workflow its failing.
    In the ODBC connection I have put the following:
    User Name: PmNullUser
    Password: PMNullPassword
    Connection String: NAME of ODBC connection i.e. ExcelFile (DSN NAME)

    Thanks


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact