DSXchange

Thanks Craig for the info.

I have a file with 100 records and out of those records I need to get 10% of records in file 1 and 90% of records in file 2. Please advise me on how to achieve this.

Hi chulett
Thanks for the response, the source system has decided to send the source files with out the UNIX newline (\n) in the column.

Hi craig
The target column is also same "SQL Type = Varchar, Extended = Unicode, Length = 4000 "
I am trying to load the data in staging area.

And thanks for the FYI will take care of it going forward...

Hi, I am trying to load a delimited file using sequential stage to oracle database. while loading few records are rejected with warning messages as below: ORA-01461: can bind a LONG value only for insert into a LONG column ORA-03106: fatal two-task communication protocol error ORA-01483: invalid len...

Yeah I was referring to the address column, I am getting the UNIX new line in the address column.

I have a delimited file and I am getting UNIX newline (\n) in the column, and I wanted to read the records along with the UNIX newline and load the same to database. Below is the Format of the file used while reading the file in sequential stage: Record level --> Final delimiter = end --> Record del...

Thanks All for the replies we have decide it do in sequence......

Hi All
I have a scenario where i need to check if file exsist or not if the file exsists i need check the count and if the count >0 (wc -l >0) then 1
else 0 this should be done in Execute Command stage.


if (! -e "path/file_name")
then
if(wc-l >0 then 1 else 0)
Else 0
fi