DSXchange

Hi All,

I have a relatively simple job and part of it is to take two sequential files and put through a funnel to combine them. They have different attributes on input, so I wanted to set the output columns to a single fixed width field (the same for both files) and then put through the funnel.

However... when creating output links from the sequential files, the links are defaulting to 'Reject Links' and thus preventing me from playing around with any of the column properties.

Any help/guidance is much appreciated.

Regards
StuM

Try chaging the link type or check the reject option. Your problem is still not clear.

Regards
Ashwin

ashwin141 wrote:Try chaging the link type or check the reject option. Your problem is still not clear.

Thanks.

Basically the job functions are:

* Read in a sequential file
* Use a transform to split:

1. Header to another transform, which converts the format and writes out to a sequential file.
2. Data to a sequential file which is then sorted (in partitioning).

What I want to do is pull the two files (header date and data) into a funnel to combine into a single output file.

When I draw a link from the sequential files to the funnel, they appear as dotted lines and are defined as reject links.

Where would I find the setting to re-define the link to regular output, not reject?

Thanks
StuM

Are you trying to do this in PX or Server?

ashwin141 wrote:Are you trying to do this in PX or Server?

In PX...

Thanks
StuM

Hi

If you are trying to do this in PX then it is not possible. Sequentila file doesn't allow two links, as in one output and one input link. Though it can have a second reject link. Modify your job design and remove those sequential files. Directly funnel the two links. I hope it will solve your problem.

Regards
Ashwin

Brilliant! Thanks for your help Ashwin, I will modify it accordingly.

Kind regards
StuM

how can i caputer the bad records from dataset.
suppose i have 10 records .
6th and 7th records are bad records .
how to achive this any clues?

chandra wrote:how can i caputer the bad records from dataset.
suppose i have 10 records .
6th and 7th records are bad records .
how to achive this any clues?

Hey chandra

This is not fair to hack someone's post. You should post a new one.

Thanks
Sam

im sorry !
our questions are allmost all same ..
so i tought better write in same