Most of the
times we came across scenarios where we are receiving multiple files from same
source ( upstream applications ) or may be same type of data from different
applications and we need to load all of
them in same target .
For these
kind of screnarios informatica is having feature called indirect file loading.
In indirect load type we provide the file name which is having list of files (
paths) which we want to load . and informatica will refer this file and take all
files mentioned in it .
Example :
I am having 3 data files region wise
and I am having 1 list file where I mentiond all my files ( as all are in same
folder no path required elseu can mention full path)
I am having
target as Table in oracle as below .
Now a simple
Mapping with source will be flat file ( take any file from above as all will
have same format ) and target will be
oracle table metioned above.
We can add
also a port for currently processed file name so that we can use this name if
we need it .
We can add
it by property of source like below.
After
creating workflow we have to set some important session properties as below .
As we can see three highlighted properties .which will pick from list file all files names we want to load .
After
extecuting workflow I will get all records from all 3 files in single table.
You can see
below log it picked all files .
And we get
all records in table
Thats All .