Post by Admin on Mar 16, 2014 18:55:35 GMT
How are the sources and targets definitions imported in informatica designer? How to create Target definition for flat files?
When you are in source analyzer there is a option in main menu to import the source from database, Flat file, cobol file & xml file, by selecting any one of them you can import a source definition. When you are in warehouse designer there is an option in main menu to import the target from database, xml from file and xml from sources you can select any one of these.
There is no way to import target definition as file in informatica designer. So hile creating the target definition for a file in the warehouse designer it is created considering it as a table , and then in the session properties of that mapping it is specified as file.
When you are in source analyzer there is a option in main menu to import the source from database, Flat file, cobol file & xml file, by selecting any one of them you can import a source definition. When you are in warehouse designer there is an option in main menu to import the target from database, xml from file and xml from sources you can select any one of these.
There is no way to import target definition as file in informatica designer. So hile creating the target definition for a file in the warehouse designer it is created considering it as a table , and then in the session properties of that mapping it is specified as file.