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

Informatica - Why is meant by direct and indirect loading options in sessions?




1012
views
asked marvit September 20, 2014 08:04 AM  

Why is meant by direct and indirect loading options in sessions?


           

1 Answers



 
answered By vishnoiprem   0  
Direct loading can be used to Single transformation where as indirect transformation can be used to multiple transformations or files

In the direct we can perform recovery process
but in Indirect we cant do it

when we use multiple source files, we create a file containing the names and directories of each source file we want the Power Center Server to use. This file is referred to as a file list.
when configuring the session properties,choose Indirect in the Source File type field,enter the file name of the file list in the Source File name field and enter the location of the file list in the Source File Directory field. When the session starts, the Power Center Server reads the file list, then locates and reads the first file source in the list. After the Power Center Server reads the first file, it locates and reads the next file in the list.
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