Scenario with Sequential file for the Reject/Load selection

vamsi2508 · Post by **vamsi2508** » Wed May 25, 2011 11:10 pm

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.

ray.wurlod · Post by **ray.wurlod** » Wed May 25, 2011 11:22 pm

Define the field as Char(1) on the input link metadata.

peddakkagari · Post by **peddakkagari** » Wed May 25, 2011 11:47 pm

Create stage variable by using length function

If Len(input_column)=1 then Y else N

then put the stagevariable=Y for target and N for reject

Thanks,
Sreekanth

vamsi2508 · Post by **vamsi2508** » Thu May 26, 2011 12:10 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..

ray.wurlod · Post by **ray.wurlod** » Thu May 26, 2011 12:24 am

Define a second field consisting of VarChar data type.

singhald · Post by **singhald** » Thu May 26, 2011 12:31 am

add neviorment variable $APT_IMPORT_REJECT_STRING_FIELD_OVERRUNS and mark it to YES

which will reject the input records from sequential stage if any field value length exceed to defined varchar.

SURA · Post by **SURA** » Thu May 26, 2011 12:46 am

These type of rejects may give warnings. In some projects they may not allow warnings.

Keep it in mind.

DS User

ray.wurlod · Post by **ray.wurlod** » Thu May 26, 2011 12:49 am

Define a second field consisting of VarChar data type.

vamsi2508 · Post by **vamsi2508** » Thu May 26, 2011 1:26 am

can you please elaborate sir ? On what exactly the meaning/implementation of Define a second field consisting of VarChar data type and how it is going to help me achieve the requirement. Thank you..