Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1287
  • Last Modified:

Source Qualifier in informatica powercenter.

Is there any option in informatica powermart to make sure that the rows returned by the source qualifier will be processed in the top to down fashion.
0
kavitag123
Asked:
kavitag123
1 Solution
 
kanemaCommented:
In Informatica 8.1 there is an option under the Properties tab of the Source Qualifier called Number of Sorted Ports.  (It may exist in previous version but don't know for sure.) This field is set to 0 by default, but you can increase it to the number of columns you wish to sort by.  You will need to put the primary column to sort by in the first port, and the next column in the second port and so on for the number of sorted ports you define.  I know this works when the source is a database.  It basically adds an order by clause to the SQL it generates.
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now