Results 1 to 2 of 2

Thread: HI Plz respond to this question

  1. #1
    Junior Member
    Join Date
    Jan 2007
    Answers
    1

    HI Plz respond to this question

    how can we do performance tuning using query hints(source bottleneck)??? in informatica tool


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

    Re: HI Plz respond to this question

    Hi Nagu,
    You can add hints only where you can modify the SQL statements . i,e in Source Qualifier and Lookups. We add an hint when we want to do Cost Based Optimization. (CBO)
    If there is a source bottleneck , we can modify the Source Qualifier to add hints. Usually it is a good practice to bring all the data into Informatica with SQ and perform the filter thereafter, instead of trying to filter in SQ itself.
    There are many tricks to solve the bottleneck. I can give more input based on what is excatly the issue and how many sources and volume of data u r dealing with.
    Hope this helps!


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