I wants to implement first() function in datastage. As you know we have first function in aggre trfm stage in informatica . In my case we are getting the values from source seq. file, and it is a migration from informatica to datastage. So, we need to replace same logic in PX job. Please tell me how to implement this.
Thanks!
venkat.
first() implemation in datastage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 94
- Joined: Fri Dec 14, 2007 3:22 am
As a Datastage forum, members here are not likely to necessarily know anything about Informatica. I have used it previously, albeit some 7-8 years ago now, yet even I can't recall what the first function does.
If you explain what it is you need to achieve, forgetting all about Informatica, it would be far simpler for anyone to answer your query. I'd guess, from the fact you are using it in an aggregation, that it's some kind of min/max function though (i.e. keep first).
If you explain what it is you need to achieve, forgetting all about Informatica, it would be far simpler for anyone to answer your query. I'd guess, from the fact you are using it in an aggregation, that it's some kind of min/max function though (i.e. keep first).
Mark Winter
<i>Nothing appeases a troubled mind more than <b>good</b> music</i>
<i>Nothing appeases a troubled mind more than <b>good</b> music</i>
DataStage also has an aggregator stage with similar functionality. Have you tried using that?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Remove Duplicates stage is the easiest way to capture the first record of each group.
As noted, the keyChange column that can be generated by a Sort stage can also be used to flag the first record in each group.
As noted, the keyChange column that can be generated by a Sort stage can also be used to flag the first record in each group.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.