GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Tech FAQs  >  DataStage
Go To First  |  Previous Question  |  Next Question 
 DataStage  |  Question 69 of 140    Print  
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?


  
Total Answers and Comments: 0 Last Update: June 15, 2007     Asked by: Jackie Savinon 
  
 Sponsored Links

 

No answers are posted for this question yet.
Be the first to answer it!


 Related Questions

Hi ,in my pc i am unable to login to the Ascential datastage 7.1. whatever the hostname i am specifying... i m getting the error statement as/...Failed to connect to host: project:UV (The specified hostname is not valid, or the host is not responding(81011)n when i explored the online documentation file....the reason is given as.......follows....When defining a connection to a remote Uni Verse database, a new uvodbc.config entry is added...It\'s important that the lastline (host=name) is terminated
Read Answers (6) | Asked by : Madhavi
Hi ,in my pc i am unable to login to the Ascential datastage 7.1. whatever the hostname i am specifying... i m getting the error statement as/...Failed to connect to host: project:UV (The specified hostname is not valid, or the host is not responding(81011)n when i explored the online documentation file....the reason is given as.......follows....When defining a connection to a remote Uni Verse database, a new uvodbc.config entry is added...It\'s important that the lastline (host=name) is terminated
We have the Datastage server7.5 installed on Unix machine. We need to have a DSN to connect to the database which is on some other unix machine.please let me know it is enough if we create a DSN at the client machine or do we have to change the config file in UNIX?It is very urgent for us and we are not able to solve?pls help me in this regard.Madhavi
Read Answers (1) | Asked by : Madhavi
Latest Answer : To handle the error handling you can use the reject link option available in the transformer stage. ...
Read Answers (1) | Asked by : Amar
Latest Answer : Parallel extender is that the parallel processing of data extraction and transformation application . there are two types of parallel processing 1) pipeline parallelism 2) partition parallelism. ...
Read Answers (2) | Asked by : Deepak Prasad
View Question | Asked by : saritha.ppr
If a DataStage job has aborted after say 1000 records, how to continue the load from 1000th record after fixing the error?
Read Answers (6) | Asked by : etl
Latest Answer : two links avilable in datastage 1.primary link 2. reference linkprimary link means:strightly forwarded standard line ________________reference link means:horizentling table------------------------------> ...
I am new to DataStage can we need to load a excel file which has both ARABIC and ENGLISH text. Here my source id IBM DB2. If I want to display the Arabic content in my browser I need to store it in the UNICODE format in the Database. Can any one tell how to store the content in a excel file as UNICODE NLS . In DataStage the option has been provided only for Sequential files.Thanks in advance.Regards,Kris.
We have to choose between Datastage and Informatica.Which of these is better?Our DW is approx. 3-5 GBEnvironment is NT.We have INFA 7.2 and the business we just took over has Datastage 7.5. Here's one side of the story:A customer that recently migrated from Ascential DataStage 7.5 to Informatica PowerCenter 7. The customer has identified that Informatica outperformed Ascential DataStage in the following areas.· Performance - Informatica PowerCenter 2.5x faster than DataStage
Read Answers (1) | Asked by : Amar

 Sponsored Links

 
Related Articles

How EDI work with XML

How EDI work with XML EDI and XML systems have been seen as the opportunity to create a holistic approach to data information exchange that can deliver and process simple durable and effective business transactions by electronic means To achieve this methods must be employed that are not only of val
 

C++ Standard Input Output Stream

C Standard Input Output Stream In this C tutorial you will learn about standard input stream and standard output stream explained along with syntax and examples C programming language uses the concept of streams to perform input and output operations using the keyboard and to display information on
 

Importance of Header Files

What is the importance of header files? The main role of header file is it is used to share information among various files. In brief, if we have several functions say 4 functions named as f1, f2, f3, f4 placed in file say sample.c and if all the functions want to get accessed by each other then all
 

Top 10 Application Security Vulnerabilities in Web.config Files - Part One

These days, the biggest threat to an network security comes from its public Web site and the Web-based applications found there. Unlike internal-only network services such as databases-which can be sealed off from the outside via firewalls-a public Web site is generally accessible to anyone who wan
 

Top 10 Application Security Vulnerabilities in Web.config Files - Part Two

Some of the most common and dangerous application security vulnerabilities that exist in ASP.NET Web-based applications come not from the C# or VB.NET code that make up its pages and service methods, but instead from the XML code that makes up its Web.config files. Incorrect configurations can open
 

Understanding The Work Structure of Project Management

Understanding The Work Structure of Project Management The project management process requires a team to be formed who can successfully complete a project At the head of the team is the project manager and they must be able to delegate the tasks of the project to each member The ability to do this p
 

Group Discussion - How To Work With Group Members

How To Work With Group Members When you participate in group discussions it important to realize that the other members may not share the same views as you In fact they may come from a different cultural or ethnic background Generally the members of the group will have one of two communication style
 

WebSphere V5.0 : Web Development - Work with Web Application Deployment Descriptor

WebSphere V5 0 Web Development Work with Web Application Deployment Descriptor In this tutorial you will learn about WebSphere V5 0 Web Development Work with Web Application Deployment Descriptor using web xml editor Configuring Web applications using the Web deployment descriptor editor The Web dep
 

WebSphere V5.0 : Workbench Basics - Work with Perspectives

WebSphere V5 0 Workbench Basics Work with Perspectives In this tutorial you will learn about Workbench Basics Work with Perspectives Perspectives Opening perspectives Switching between perspectives Changing where perspectives open Specifying the default perspective Configuring perspectives Java pers
 

Live DataStage Interview Questions

Thanks to our site visitor Manoj for sending these DataStage Interview Questions You can find the updated questions here Live DataStage Interview Questions Published by Manoj G on 05 24 2005 Thanks to our site visitor Manoj for sending these DataStage Interview Questions You can find the updated que
 

About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape