Unable to read data from Sequential stage

vitumati · Post by **vitumati** » Thu Mar 17, 2011 5:56 am

Hi Friend.

I've one file it contains 9 records(EceptionDb).If I open file with .csv format then I can able see 9 records.then I design a job I use the sequential file as source Simple I loading in target.While reading data It showing 26 records but actually it contains 9 records.
So sequential file not able read properly.In meta data I've column like Description_c due to this field its splitting into multiple records.

Can you please help me this issue.

Thanks...!!
VijayKumar T

priyadharsini · Post by **priyadharsini** » Thu Mar 17, 2011 6:00 am

Please provide some sample data like how the split is happening.

vitumati · Post by **vitumati** » Thu Mar 17, 2011 6:34 am

Hi.......

In my source contains 9 records.

Id,Org_Name,Websit,Comment_c,Client_Id,.......

In the above MetaData Coment_c filed size 3200 bits,This field comment about the client.While enter the comment if user press enter button then sequential file consider as newline character from enter position onwards it treat as another line so that even though my source contains 9 records it showing more then 9 records

Thank..!!
VijayKumar T

chulett · Post by **chulett** » Thu Mar 17, 2011 6:37 am

Use a Server job, the Sequential File stage there has a 'Contains Terminators' option the PX one doesn't for some reason, it will easily read your 9 records properly.

chulett · Post by **chulett** » Thu Mar 17, 2011 6:41 am

Any particular reason you posted this question three times?

ps. I deleted the other two, in case you were wondering.