DSXchange

Input

0001
0002
0003
0001,0002
0005
0003,0004

Source is sequential file and Pipe delimiter, how can we read source data if it like 0001,0002 in 1 line.

When i read source file it is unable to read after comma.It is reading all 6 lines data but not after comma data.

So... when you say "in one line" you actually mean "in one column", yes? And are you certain you set the delimiter to a pipe in the stage? I'd also be curious what the data type of this column is...

Datatype is Varchar(10), yes i mean one column.

And the pipe delimiter? I'm not sure off the top of my head why you'd be seeing the behaviour you are describing unless the delimiter was set to a comma in the stage.

Thanks Craig, you are right i set delimiter to comma instead of pipe.

So, resolved?