All,
I have a job which works like this
SequentialFile --> Transformer --> HashFile
I have some attributes in the seq. file and I want to do a select on those attributes where attribute_value = 'XXXX'. I tried specifiying this condition as a constraint in the transformer where mention attribute_value='xxx' but the hashfiles continues to be populated with all the data from the sequential file.
Could some on help me on this
Thnx.
Aditya.
Loading only values of a particular attribute value
Moderators: chulett, rschirm, roy
aditya,
the method you described is the normal way of filtering data. Perhaps you have a syntax error or similar error in your constraint. Most likely your "attribute_value" is specified incorrectly, you can check that and perhaps post your exact constraint to this thread.
-Arnd.
the method you described is the normal way of filtering data. Perhaps you have a syntax error or similar error in your constraint. Most likely your "attribute_value" is specified incorrectly, you can check that and perhaps post your exact constraint to this thread.
-Arnd.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
That suggests that every row in the sequential file satisfies your condition, or that you have mistyped the constraint expression.
Can you check the latter?
Use the Debugger to step through a row at a time, inspecting (watching) the values of the attribute(s) as you step through. Set a breakpoint to pause when the condition is not met.
Can you check the latter?
Use the Debugger to step through a row at a time, inspecting (watching) the values of the attribute(s) as you step through. Set a breakpoint to pause when the condition is not met.
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.
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am