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
Error reading files using File Pattern
Moderators: chulett, rschirm, roy
Error reading files using File Pattern
Last edited by chandu123 on Mon Nov 07, 2016 3:37 pm, edited 1 time in total.
HB