What's the best Stage for this scenario

[vijayrc]

A newbie. 1st hands-on week..need some help..
In this scenario, which is the 'ideal/best' stage ??
Thanx, V

I have input Charge records in this sequence,
Rec1: AAAAAA $100 01 02 03 04
Rec2: BBBBBB $150 01 04 07
Rec3: CCCCCC $120 01 03 04 07

and I need to create different output files based on the values

AAAAA $100
BBBBB $150
CCCCC $120 in file1 corresponding to '01'

AAAAA $100 in file2 corresponding to '02'

AAAAA $100
CCCCC $120 in file3 corresponding to '03

AAAAA $100
BBBBB $150
CCCCC $120 in file4 corresponding to '04'

BBBBB $150
CCCCC $120 in file5 corresponding to '07'

[opdas]

You can try using "Filter Stage"

A newbie. 1st hands-on week..need some help..
In this scenario, which is the 'ideal/best' stage ??
Thanx, V

I have input Charge records in this sequence,
Rec1: AAAAAA $100 01 02 03 04
Rec2: BBBBBB $150 01 04 07
Rec3: CCCCCC $120 01 03 04 07

and I need to create different output files based on the values

AAAAA $100
BBBBB $150
CCCCC $120 in file1 corresponding to '01'

AAAAA $100 in file2 corresponding to '02'

AAAAA $100
CCCCC $120 in file3 corresponding to '03

AAAAA $100
BBBBB $150
CCCCC $120 in file4 corresponding to '04'

BBBBB $150
CCCCC $120 in file5 corresponding to '07'

[vijayrc]

That's exactly I tried. So would a Filter still write the same input records into 2/more different output records, based on the match criteria ??
Thanks, V

You can try using "Filter Stage"

A newbie. 1st hands-on week..need some help..
In this scenario, which is the 'ideal/best' stage ??
Thanx, V

I have input Charge records in this sequence,
Rec1: AAAAAA $100 01 02 03 04
Rec2: BBBBBB $150 01 04 07
Rec3: CCCCCC $120 01 03 04 07

and I need to create different output files based on the values

AAAAA $100
BBBBB $150
CCCCC $120 in file1 corresponding to '01'

AAAAA $100 in file2 corresponding to '02'

AAAAA $100
CCCCC $120 in file3 corresponding to '03

AAAAA $100
BBBBB $150
CCCCC $120 in file4 corresponding to '04'

BBBBB $150
CCCCC $120 in file5 corresponding to '07'

[us1aslam1us]

Yes it will but it depends on the condition ur giving there.

Thanks
sam

[shepli]

I am not able to see the Filter Stage in my Palette, can anybody give me some instruction on where it is? Thanks.

[kumar_s]

Is that you couldnt find all of a sudden?
Try to do a customization. Right click on the pallet and go to Custamiztion-->Custamize and select under Parallel processing.

[shepli]

Thanks for your reply. It is not "suddenly", instead, I have never used it, and even seen it.
I just found out that I only have Database, File, Processing("Server Processing"), Real Time, and so on, but not the Parallel Processing in my palette. Does that mean the Parallel Processing is not installed at all? I may need to talk to our IT person.

[DSguru2B]

You can also use a Trasformer and add constraints to each stage.
Did you try creating a new parallel job. Unless you dont do that you will not see the Parallel palete.
Secondly, if you are in a old project when there was no PX in your company, then may be even if you open the PX job under that project, you will not be able to see the pallete. It depends on the way the upgrade is made.

[kumar_s]

Even if a sequence job was opened, customization should give the full list of stages available.
Make sure your server is installed with PX.
If you click on File--->New, are you able to see, Parallel jobs or only Sequence jobs.

[ray.wurlod]

Filter stage is only available in parallel jobs. You posted on the parallel forum, which is why folks replied as they did. Your only possible choice of stage in a server job is the Transformer stage.