Scenario with Sequential file for the Reject/Load selection
Moderators: chulett, rschirm, roy
Scenario with Sequential file for the Reject/Load selection
hi friends,
Here is a problem i am currently facing in my module.
I am reading a file using a sequential file stage. The column in the file is of Char data type.
It contains records with
single character - for ex : A
double characters - for ex : AA
more than two : for ex : AABBCCC
the requirement is if the record in the column is having one character, then it should get loaded. if the record is of more than one character, i must go to the reject file.
have a look at the following data, for clear picture of the scenario:
Sample_column (datatype:char)
Y -------------------------------------------SHOULD GO TO THE TARGET
YK -----------------------------------------SHOULD GOT TO THE REJECT
YT-----------------------------------------REJECT
C-----------------------------------------LOAD
CB---------------------------------------REJECT
CCN--------------------------------------REJECT
KJ--------------------------------------REJECT
K -----------------------------------------LOAD
LL--------------------------------------REJECT
Kindly help me..Thanks alot for your time and patient reading of my issue.
Here is a problem i am currently facing in my module.
I am reading a file using a sequential file stage. The column in the file is of Char data type.
It contains records with
single character - for ex : A
double characters - for ex : AA
more than two : for ex : AABBCCC
the requirement is if the record in the column is having one character, then it should get loaded. if the record is of more than one character, i must go to the reject file.
have a look at the following data, for clear picture of the scenario:
Sample_column (datatype:char)
Y -------------------------------------------SHOULD GO TO THE TARGET
YK -----------------------------------------SHOULD GOT TO THE REJECT
YT-----------------------------------------REJECT
C-----------------------------------------LOAD
CB---------------------------------------REJECT
CCN--------------------------------------REJECT
KJ--------------------------------------REJECT
K -----------------------------------------LOAD
LL--------------------------------------REJECT
Kindly help me..Thanks alot for your time and patient reading of my issue.
Vamsi Karthik
Consultant/DWBI
Consultant/DWBI
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 26
- Joined: Thu Aug 12, 2010 12:07 am
Thank you very much sir..
But i need to send the records with more than one character to the reject AT THE SOURCE LEVEL IT SELF. Not after any transformations. Hope i am clear..
At the source level itself, while reading ,if the sequential file stage encounter a record with more than one column, immediately that record should go to the source level reject.
Even if i define the metadata to be Char(1) , the for each record it takes the first character and loads..if wont mind how many characters are there..
But i need to send the records with more than one character to the reject AT THE SOURCE LEVEL IT SELF. Not after any transformations. Hope i am clear..
At the source level itself, while reading ,if the sequential file stage encounter a record with more than one column, immediately that record should go to the source level reject.
Even if i define the metadata to be Char(1) , the for each record it takes the first character and loads..if wont mind how many characters are there..
Vamsi Karthik
Consultant/DWBI
Consultant/DWBI
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: