GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Tech FAQs  >  DataStage
Go To First  |  Previous Question  |  Next Question 
 DataStage  |  Question 19 of 123    Print  
How to use Excel file as input in DataStage??

  
Total Answers and Comments: 2 Last Update: May 09, 2006     Asked by: Sowmya 
  
 Sponsored Links

 
 Best Rated Answer
—

No best answer available. Please pick the good answer available or submit your answer.
April 23, 2006 19:31:36   #1  
omkar        
RE: How to use Excel file as input in DataStage??
store input excel file as .csv file and use sequencial file stage to read that file..!!!
 
Is this answer useful? Yes | No
May 09, 2006 05:02:42   #2  
aranjan Member Since: April 2006   Contribution: 3    
RE: How to use Excel file as input in DataStage??

You can use excel file as input by importing the .xls file.

step1 --> Go to Administrative Tools -> Data Source (ODBC) --> System DSN. Click on Add button and configure the corresponding .xsl file in your system DSN. Make sure that workbook contains the name of your excel sheet.

Step2 --> Import the excel file into the datastage as ODBC table definition.

Step3 --> Use ODBC stage as input stage.

You should be able to use excel file very effectively. Please let me know if you face any problem.


 
Is this answer useful? Yes | No

 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
View Question | 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------------------------------> ...
Can a sequential file stage can read the path from other sequential file. in which the data is stored
Latest Answer : what type of error dud you got.explain error. ...
Read Answers (1) | Asked by : mallikharjuna reddy

 Sponsored Links

 
Related Articles

Using XML with Microsoft Excel

Using XML with Microsoft Excel One of the most useful features for a programmer would be Microsoft Excel s capability to support XML schemas which are user defined Though it is not a very prominent feature which can be obviously noted it still exists and is very functional tool In simple English it
 

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
 

What is Data File

In a logical data model, the conceptual data model which is based on the business semantic is being defined. Thus, entities and relationships and corresponding table and column design, object oriented classes, and XML tags, among other things are being laid regardless of the database will be physica
 

PHP Tutorials - File manipulation (Part-2)

File manipulation Part 2 In this PHP Tutorial you will learn the 2nd Part of File Manipulation Reading lines from a file Reading arbitrary amounts of data from a file Writing to a file Creating directories Removing a directory and Opening a directory for reading mosgoogle Reading lines from a file T
 

PHP Tutorials – File manipulation (Part 1)

PHP Tutorials File manipulation Part 1 In the PHP Tutorial You will learn about File manipulation Part 1 Checking file existence A file or directory Determining file size Creating and deleting files and Opening a file for writing reading or appending mosgoogle Checking file existence You can test
 

C Programming - File management in C

C Programming File management in C In this tutorial you will learn about C Programming File management in C File operation functions in C Defining and opening a file Closing a file The getw and putw functions The fprintf fscanf functions Random access to files and fseek function mosgoogle C suppor
 

C Programming - Managing Input and Output Operations

C Programming Managing Input and Output Operations In this tutorial you will learn about Single character input output String input and output Formatted Input For Scanf Input specifications for real number Input specifications for a character Printing One Line Conversion Strings and Specifiers Speci
 

The File Types Editor

The File Types Editor The File Types Editor can be used to create the required registry to establish a file association for the application being installed A file association is simply a link between a particular file extension and a particular application For example the file extension xls is norma
 

Oracle 10g Tutorials- SQL*Loader - Input Data and Datafiles

Oracle 10g Free Training SQL Loader Input Data and Datafiles In this tutorial you will learn about SQL Loader Input Data and Datafiles Fixed Record Format Variable Record Format and Stream Record Format mosgoogle SQL Loader Input Data and Datafiles SQL Loader reads data from one or more files or ope
 

Working with File System in .NET

In this tutorial you will learn about Access and Manipulate Data Working with Disk Files Browsing for Files Streams and Backing Stores Using the FileStream Class Using the StreamReader and StreamWriter Classes Using the BinaryReader and BinaryWriter Classes Access and Manipulate Data Working with Di
 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape