Reject Output Link - how to amend
Moderators: chulett, rschirm, roy
Reject Output Link - how to amend
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
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
Thanks.ashwin141 wrote:Try chaging the link type or check the reject option. Your problem is still not clear.
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
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
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
i have some bad records in dataset
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?
suppose i have 10 records .
6th and 7th records are bad records .
how to achive this any clues?
chandra ,
Hyd
Hyd
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
Re: i have some bad records in dataset
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