Results 1 to 4 of 4

Thread: How to read files using informatica

  1. #1
    Contributing Member
    Join Date
    Apr 2007
    Answers
    46

    How to read files using informatica

    Hi,

    I have unix directory, where i got different number of files daily.
    Now i have to read these files using informatica.I cant use variable or parameter.
    can anybody suggest me any idea for this?

    Reeta


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

    Re: How to read files using informatica

    Hi,
    I need to know few more things before i can suggest you idea.
    Do u know all the possible set of filenames & their structure which will be coming, even if some fo them don't come?

    Do u also want to apply some transform logic or u only want to dump them into target using straight pull?

    Let me know these details.

    Barun
    Quote Originally Posted by reetasharma108 View Post
    Hi,

    I have unix directory, where i got different number of files daily.
    Now i have to read these files using informatica.I cant use variable or parameter.
    can anybody suggest me any idea for this?

    Reeta



  3. #3
    I am the DON
    Join Date
    Apr 2006
    Answers
    99

    Post Re: How to read files using informatica

    Quote Originally Posted by barunkumar
    Hi,
    I need to know few more things before i can suggest you idea.
    Do u know all the possible set of filenames & their structure which will be coming, even if some fo them don't come?

    Do u also want to apply some transform logic or u only want to dump them into target using straight pull?

    Let me know these details.

    Barun
    Don't know why this Barun is creating confusions to the Guests/Geeks... Please avoid this kind of replying....

    Quote Originally Posted by reetasharma108
    I have unix directory, where i got different number of files daily.
    Now i have to read these files using informatica.I cant use variable or parameter.
    can anybody suggest me any idea for this?

    If you have data files in Unix, you can write Sheel scripts why which you can call PL/SQL procedures to load the data.
    This is by using shell scripting.

    By using informatica, you can use stored procedure transformations to call the PL/SQL Procedures.

    Please rectify if any misssing..!

    Sanghala


    Sanghala

    If you are satisfied with my reply. Please click “Thanks” button which increases the reputation and can serve you better.

  4. #4
    Contributing Member
    Join Date
    May 2007
    Answers
    45

    Re: How to read files using informatica

    I don't think B Arunkumar is wrong. Some times before giving suggestion on the question..we must have known some things clearly. He might have known answer or we can get some clue from them.
    I am requesting don't under estimate others.

    Thx
    SRIRAM N
    Hope Everything Good

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