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

How to use Excel file as input in DataStage??

Asked by: Interview Candidate | Asked on: Apr 21st, 2006
Showing Answers 1 - 5 of 5 Answers
omkar

Answered On : Apr 23rd, 2006

store input excel file as .csv file and use sequencial file stage to read that file..!!!

Yes  1 User has rated as useful.
  
Login to rate this answer.
aranjan

Answered On : May 9th, 2006

View all answers by aranjan

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.

  
Login to rate this answer.
vikram

Answered On : Jul 18th, 2011

I did follow the step1, when I try to import excel file into datastage as ODBC table definition, when I select DSN name and OK then it says NO MATCHES FOUND. plz help me.

Vikram

  
Login to rate this answer.
srinu5077

Answered On : Jan 4th, 2012

View all answers by srinu5077

I did same as step1, but when i import the metadata it asking username and password, when press ok button it shows NO MATCHES FOUND, pls help me

Thank you
Regards
Srinivas

  
Login to rate this answer.
joel

Answered On : Jun 20th, 2012

The above answer is wrong.

Please follow the steps below to load the excel in dataastage :-
first open excel sheet and open->saveas-> then save the file as .csv extension
while importing u have to select .csv instead of txt
second take the sequential file stage and read the .csv file (just give the file path with file name)

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

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.