DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
suja.somu
Participant



Joined: 07 Feb 2013
Posts: 69

Points: 688

Post Posted: Fri Mar 01, 2013 11:57 pm Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: Parallel
OS: Windows
Can anyone explain me the below question.

What all the possible reasons, a sequential file stage will reject data to a reject link.

Suppose I have 4 columns as below

Col1 varchar Not Null,
Col2 varchar Null,
Col3 varchar Not Null
Col4 varchar Null
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 51928
Location: Sydney, Australia
Points: 281959

Post Posted: Sat Mar 02, 2013 1:48 pm Reply with quote    Back to top    

Is this an interview question? As a general rule strings are never rejected. But you have not provided any information about Null Field Value property or the data values in the file, so a ...

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Sydney and Melbourne
Rate this response:  
Not yet rated
suja.somu
Participant



Joined: 07 Feb 2013
Posts: 69

Points: 688

Post Posted: Sun Mar 03, 2013 10:49 pm Reply with quote    Back to top    

Thanks Ray.

This is not a interview question. I did a search in help and I could not find any details on the reasons of the rejects in a sequentila file stage, so I posted in the forum.

I have a requirement to read a sequential file ( csv file ) and load into target file.

As per the metadata of the csv file, for the Null values, the I have set the Null field value property to handle the nulls.

Other than this, what are the possible rejects of the stage.
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 51928
Location: Sydney, Australia
Points: 281959

Post Posted: Mon Mar 04, 2013 1:21 am Reply with quote    Back to top    

Only one that I can imagine - reading a null (null field value) for Col1 or Col3 where there is no default value defined.

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Sydney and Melbourne
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours