I would like to know whether it is possible to create an outer join when I link the data from a HF to a transformer. The situation is I retrieve data from source table and transform them by using a transformer. From the very transformer, I need to take data from a hashed file so I create a link between the HF and the transformer. By default, the link is based on the equality of the 2 columns. But...

?A byte stream file was ftp'd from an HP3000 MPE/iX server to the ETL server (windows 2000). The column values are enclosed in double quotes (") and the spaces within these are not lost Comma (,) is the column delimiterHowever, the newline character is converted to binary (vertical rectangular box) and is not recognized as line (row) terminator either by notepad or the datastage sequential file stageSo...

Currently, the total is converted to ASCII, even tho the individual records are stored as EBCDIC.