GeekInterview.com
Series: Subject:
Question: 104 of 172

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?
Asked by: Interview Candidate | Asked on: Jun 15th, 2007

This Question is not yet answered!

Related Open Questions

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

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.