Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.
Does DataStage work with byte stream, binary files
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 delimiter
However, 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 stage
So when trying to View Data thru the Sequential File Stage, it retrieves the entire file as one row and fails with the message:
CopyOfLoadProcDetail..TEST_PROC_DETAIL_RAW.From_Raw: read_delimited() - row 1, too many columns in record
Does DataStage work with byte stream, binary files?
This Question is not yet answered!
Related Answered Questions
Related Open Questions