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

Informatica - What are the limitations for bulk loading in informatica for all kind of databases and transformations?




3472
views
asked marvit January 22, 2015 08:57 AM  

What are the limitations for bulk loading in informatica for all kind of databases and transformations?


           

3 Answers



 
answered By Anuj   0  

You can have index on table on your target table given that, in the relational connection that you are using you have checked on enable paralell.

flag   
   add comment

 
answered By ashif   0  

And also there exist an additional point:

Its not possible to load a table having index on it . So we need to drop and recreate or rebuild the indexes during the load.

flag   
   add comment

 
answered By vishnoiprem   0  
Bulk load is used for external loaders and in bulk load we will not write information to datalog file so if any recovery is needed it is not possible
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