Home > Software > Data-Warehouse > Informatica
Interview Questions   Tutorials   Discussions   Programs   

Informatica - How can we load 365 flat file to a single fact table (target) as a history load in single mapping?




707
views
asked marvit September 20, 2014 08:00 AM  

How can we load 365 flat file to a single fact table (target) as a history load in single mapping?


           

1 Answers



 
answered By vishnoiprem   0  
Use Indirect option in session properties and give file_list name. In the file list you can have actual file names with complete path.
Ex: In Session Properties SourceFileType --- Indirect and File Name xxx.txt.
xxx.txt will contain all the input file names with complete path.
like
/home/.../...filename.dat
/home/.../...filename1.dat

Loading Multiple Flat Files (INFORMATICA)

1.Creating a list file and
Creating the list file:


You can create a list file manually and specify each source file you want to load into the target in a separate line. As an example consider the following list file:

>cat customers_list.dat $PMSourceFileDir/customers_us.dat $PMSourceFileDir/customers_uk.dat $PMSourceFileDir/customers_japan.dat
 
2.Configuring the file properties in session.
 
Configuring the File Properties in Session
:

Configure the following source file properties in the session for indirect source filetype:

Source File Directory: Enter the directory name where the source file resides.
Source Filename: Enter the list file name in case of indirect load
Source Filetype: Specify the indirect option when you want to load a multiple files with same properties.
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert