What is the difference between Normal load and Bulk load?
- 5 Answers
- 48954 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
If you enable bulk loading, the PowerCenter Server
bypasses the database log.This improves session performance.
But the disadvantage is that target database cannot perform
rollback as there is no database log.
In normal load the databse log is not bypassed and
therefore the target databse can recover from an incomplete
session.The session performance is not as high as is in the
case of bulk load
| Is This Answer Correct ? | 81 Yes | 4 No |
Answer / harithareddy
normal load performance recovery is possible where as in
bulk mode it is not possible bez, there is no databaselog
to perform rollback
| Is This Answer Correct ? | 44 Yes | 4 No |
Answer / sachin
1.It is also not allow the constraint when we make Target load type as Bulk Mode
2.Also we do not allow to use indexes on database level in Bulk mode But in Normal mode we can allow indexes as well as constraint.
| Is This Answer Correct ? | 1 Yes | 0 No |
hw cn v elimate dublicate values from lookup without overriding sql?
What are the new features of Power Center 5.0?
What exactly mentioned in High level design document.can somebody explain me sequentialy.
hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks... Send me----: raghukrams@yahoo.com
Differentiate between Load Manager and DTM?
In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query
What is a passive transformation?
rank() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid order by case when opt2.dm_market_flg in ('Y', 'U') then 1 else 2 end, lkp.contact_rank) as rank1, case opt2.contact_type when 'Buyer' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, ship_to_flg desc , last_order_dt desc) when 'Decision Maker' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc , last_quote_dt desc , mailability_score desc , source_ranking desc) when 'Influencer' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, mailability_score desc, source_ranking desc) when 'Payer' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, mailability_score desc, source_ranking desc) --elu 05/28/2013 else row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, mailability_score desc, source_ranking desc) end rank2 row_number() over (partition by opt3.dim_plat_site_id, opt3.dim_site_opt_sid order by rank1,rank2) as "rank", case when "rank"<= opt3.maximum_value then 'Y' else 'N' end as include_flg
select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?
What is junk dimention?
hi all, Can anyone please tell me the relationship between informatica and business objects
Explain direct and indirect flat file loading (source file type) - informatica
Teradata 
