Error reading files using File Pattern
Posted: Wed Nov 02, 2016 11:15 am
I am reading multiple csv files using Sequential File Stage with File Pattern option. But while reading Datastage is concatenating last record of first file and first record of second file. I think that is because there is no new line character after the last record of first file. How can we address this in Datastage?
Should I set any option in sequential file stage to treat them as separate records?
EX:
F1:
abc
def
F2
xyz
mno
Current Output:
abc
defxyz
mno
Expected:
abc
def
xyz
mno
Should I set any option in sequential file stage to treat them as separate records?
EX:
F1:
abc
def
F2
xyz
mno
Current Output:
abc
defxyz
mno
Expected:
abc
def
xyz
mno