Results 1 to 5 of 5

Thread: View code that Informatica creates in backend

  1. #1
    Expert Member
    Join Date
    Oct 2006
    Answers
    209

    View code that Informatica creates in backend

    Can we view the code that Informatica creates in the back-end ?
    If yes, then how and also can we edit that code ?

    NOTE : [This question was asked by manisha.sinha]


  2. #2
    Junior Member
    Join Date
    Dec 2006
    Answers
    19

    Re: View code that Informatica creates in backend

    I still dont see any replies and I have been asking a lot of people !


  3. #3
    Junior Member
    Join Date
    Feb 2007
    Answers
    6

    Re: View code that Informatica creates in backend

    u can see the codes while giving generate and execute command in the warehouse designer


  4. #4

    Re: View code that Informatica creates in backend

    hi Manisha,
    yes, we can see them in log files, i.e., what ever we do in informatica designer, that backend SQL code will be seen in log files. These files are created by Power center server, i.e., in server folder, session logs, etc., we can check the code in log files.


  5. #5
    Junior Member
    Join Date
    Dec 2006
    Answers
    1

    Re: View code that Informatica creates in backend

    If you want to see the code snippet which Informatica generates while creating a target table
    --> generate and Execute.
    If you want to see the code snippet which Informatica generates while joining various sources in source qualifier
    --> Generate SQL in Source qualifier properties.
    If you want to see the code snippet which Informatica generates while creating a target table
    If you want to see the code snippet which Informatica generates in Update strategy
    --> Do sql override in update strategy
    And all codes you can see in the session log file.


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