DSXchange

Yeah kumar, but i have to take a folder stage in server before the XML input...but accoring to business req.. we have to take a row generator in PX..but how can i use the peek stage...can you please show me the design..

I can use like

row gen---peek--xml input--dataset?

guide me

Hi Everyone, I have problem reading the data from the Row Generator. My design is RowGen---XML Input---Dataset I have kept No. of Records 10 in Row Generator and added one column. In XML Input stage, I had loaded an .XML in Output columns and in Input i had selected the XML Source column as URL File...

Ohhhh !! am really sorry DSguru2B..forgive me for this and next time i dont repeat the same and thanks kumar for the info..... as i told i am a starter and will repeat no mistakes like this.....Sorry DSguru2B and thanks for the info DSguru2B....bye

Hey kumar, am very new to DSX and i am starting to find out the option here and hence know how to post as resolved and give ratings and am still learning for the options here..

Ohhhhhh...is it? Thanks Brian and it was very informatiove...will keep this in mind...

Yes Kumar, its resolved to my satisfaction.

Yes Kumar may be..but i dont think there is ^M in my record as well...Am reading the source file from UNIX.

Hey Brian, that worked man and now i dont see any thicked pipeline in my target... as i changed the format as the dos style in Seq File stage properties...thanks alot and this happened with few of my jobs and will put the same for those jobs also....thanks you guys for your response...

My Source is Sequential File (Flat file). Anyways, I will try increasing the width and see...and get back to u guys...thanks

yeah will try the same and this is the solution or will check for the thicked pipeline?

am viewing the data is Datastage only....that is SQL (DRS)

In the transformations, I am doing the TrimLeadingTrailing to all the records and this is the only logic am doing. But, since I mentioned it is giving the thicked pipeline only in few columns not in all the columns.

Hi,

if this is because of the extra size in the field then why it is appearing only in few columns where all the fields are of the same length? and also tried with the space as u said... Also tried with all the necessary string manipulation. Any other suggestions?

Thanks.

Hi Everyone, I just wondering why the thicked pipeline | which appears after the text in my target ODBC. For eg: my target record should appear like : TF tfr plnt to plnt But, in the target the thicked pipeline is added like TF tfr plnt to plnt | (in bold) Can anybody let me know how to elimate that...