GeekInterview.com
Series: Subject: Topic:
Question: 22 of 725

can we convert exel file to XML file using informatica ?

Asked by: Interview Candidate | Asked on: Oct 4th, 2011
Showing Answers 1 - 2 of 2 Answers
wanilkumar

Answered On : Oct 6th, 2011

View all answers by wanilkumar

There is no default driver available for reading from Excel files. You need to export the Excel file into a comma delimited or tab delimited file and then you should define a XML type Target and load it.

  
Login to rate this answer.
kumar

Answered On : Oct 21st, 2011

first we need to save the excel file in csv file and then we have xml transformation in informatica by using that we can convert csv file to xml file

  
Login to rate this answer.
vizaik

Answered On : Oct 25th, 2011

View all answers by vizaik

Excel source is possible through File DSN - Target XML also can be done - read the documentation or help for more information

  
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.