DSXchange

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

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

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

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.

Any particular reason you posted this question three times?

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