Reading the date from fixed-width flat files(variable length):įrom the source, menu click on import from fileīrowse to the location of the flat file select the file click ok In a property section set the following attributes Attributeįrom left pane select the target set the writer connection with the target low type normal Open the notepad provide the path of each source file as given belowĬreate a mapping with the name M _ file listĬreate a session with the name S_ M_ file list File list:Ī file list is a collection of the files with same type and meta data, needs to be merged using source file type indirect Creation of file list: In a properties section set the following attributes Attributeįrom left pane select the target set the customer connect with the low type normalĬlick apply and click ok If you want to enrich your career and become a professional in Informatica, then visit Tekslate - a global online training platform: " Informatica Training" This course will help you to achieve excellence in this domain. Select import fields name from first lineĬlick on next, click on next, click on next, click on finishĬreate the target definition with the name T- customer (oracle) Step3:Ĭreate a mapping with the name M _ delimited – flat fileįrom source qualifier connect the ports to targetĬreate a session with the name S_ M_ delimiter _ flat fileĭouble click the session select the mapping tab Select the location of flat file(c:/ flat file) Informatica Tutorials & Interview Questions Design a mapping to read the data from delimited flat files:įrom tools menu select source analyzer from source menu csv etc…įixed width flat files Delimited Flat FilesĮach column is separated by sum specifically characters such as comma, tab, space, semicolon, etc…Ī record of fixed length needs tobe specified into multiple columns using break pointsĪ delimiter flat file can also be known as variable length files. A flat file is an ASCII text file which is saved with extension.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |