Start Informatica Services
Start up procedure for Informatica on LINUX/UNIX
September 14, 2017
Informatica Power Center Upgrade
Informatica Power Center Upgrade Strategies
September 16, 2017
Show all

Bulk Vs Normal

Bulk Vs Normal

Bulk Vs Normal

One of the common interview questions asked during any Informatica Developer interview is

If the target database does not has a primary key but has indexes then what we would be load type to choose and what will happen if we select Bulk mode ??

The Bulk mode will fail if there are indexes defined. The solution for this is to drop the indexes and constraints defined on the target table using pre- and create them once using the post- session SQL commands.

Of course, you need to understand the reason for the Primary key, Foreign Key and the Indexes logically and see what business rules will be impacted with this change of drop and re-create and then proceed accordingly.

The Bulk mode option is used to improve overall run time by skipping or by passing the constraint check and the Integration Service does not log any errors (if any) caused by the load which will also add up to the overall run time.

If you select Normal, the Integration Service loads targets normally with the constraint checks. We can choose Bulk when you load to DB2, Sybase, Oracle, or Microsoft SQL Server. If you specify Bulk for other database types, the Integration Service reverts to a normal load.

Loading in bulk mode can improve session performance, but limits the ability to recover because no database logging occurs.

Sid
Sid
Business Intelligence Consultant and Trainer with 13+ years of extensive work experience on various client engagements. Delivered many large data warehousing projects and trained numerous professionals on business intelligence technologies. Extensively worked on all facets of data warehousing including requirement gathering, gap analysis, database design, data integration, data modeling, enterprise reporting, data analytics, data quality, data visualization, OLAP. Has worked on broad range of business verticals and hold exceptional expertise on various ETL tools like Informatica Powercenter, SSIS, ODI and IDQ, Data Virtualization, DVO, MDM.

Leave a Reply

Your email address will not be published. Required fields are marked *

Share
+1
Tweet
Pin
Share