How to read the data from XML and flat files in informatica?

Questions by sunitha ravula

Showing Answers 1 - 7 of 7 Answers

dileep671

  • Aug 3rd, 2012
 

Go to Source analyzer , then import XML Source, a wizard opens up.. select the Schema Definition (XSD) of th XML file

When you run the session, give the XML file name and XML file directory path.

  Was this answer useful?  Yes

MAHESH MANAM

  • Aug 16th, 2012
 

From flat file you use the following wys:

--> In source analyzer you can create file by manually
-->you can import file
-->you can use any of the flat file and give session properties in that correct path for this flat file

For XML

--> To read for that you can use XML parser

If you want load data form XML to flat file use the following steps

-->Use shell command to generate input flat file list.

-->Each flat file with name . from the list above is processed and written to output file under the name _O..

--> To achieve that transaction control transformation is required. For every transaction it is generated flat file with new name.

--> Expression transformation shows how to check whether new input file is processed. If new file is processed port NewFile is set to 1 (0 in other case). This is used in transaction control transformation to generate new transaction. One of more interesting issues is using local variables in the expression transformation.

If you want to read two or more flat files with same structure

-->Use any of the one table to create mapping with what ever logic you want to apply

-->In session properties use indirect type

-->Use all the flat file address store in one file

-->give that file address

  Was this answer useful?  Yes

Give your answer:

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

 

Related Answered Questions

 

Related Open Questions