Filter_17: Error occurred during initializeFromArgs().

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
jhansi
Participant
Posts: 33
Joined: Sat May 26, 2012 4:56 am

Filter_17: Error occurred during initializeFromArgs().

Post by jhansi »

my data is like this
deptno,sal
1,2000
2,3000
3,4000
1,2300
4,5000
5,1100

i want target like
target1
deptno,sal
1,2000
3,4000
4,5000
target2
2,3000
1,2300
5,1100
with out using transformerstage.i tried with
seq--->surrogate key gen--->filter--->datastet and one reject dataset

can anyone plz suggest how to do this secnario
jhansi
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Show us how you configured your Filter stage, in particular the filter WHERE clauses and associated output link identifications.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
jhansi
Participant
Posts: 33
Joined: Sat May 26, 2012 4:56 am

Post by jhansi »

in surrogate key gen... i generate sid and
in filter where clause i gave the condition like
sid%2=0.
i send all remaining records to rejectlink.
jhansi
zulfi123786
Premium Member
Premium Member
Posts: 730
Joined: Tue Nov 04, 2008 10:14 am
Location: Bangalore

Post by zulfi123786 »

The problem is with partitioning, once the surrogate key gen reads from seq file the ordering of your records is lost......

force you surrogate key stage to run in sequential and then things would work as expected.
- Zulfi
Post Reply