Informatica allows to source multiple files which have same structure and similar information.
Lets say we have month wise sales information in files.
Lets say we have month wise sales information in files.
- Jan2017_Sales.txt
- Feb2017_Sales.txt
- Mar2017_Sales.txt
and we need to load all of them in sales table in 1 go.
To do so, we will build our mapping and workflow exactly in same way as we build for single file. Only change will be in workflow property.
Select the source object and set following properties.
Source filetype = Indirect
Source filename = *_Sales.txt
As shown in figure below.
Comments
Post a Comment