explain the scenario for bulk loading and the normal
loading option in Informatica Work flow manager ???
Answer Posted / shashank
in the normal loading the taget write all the row on the
database log , while laoading the bulk loading the database
log is not come in the picture (that mean its skip the
property )so when the session got failed we can easily find
recover the seesion by the help of data base log.but in
case of bulk loading we can do .
but normaol loading is very slow as compare to bulk laoding.
Is This Answer Correct ? | 14 Yes | 3 No |
Post New Answer View All Answers
What are different types of transformations available in informatica?
Explain the features of connected and unconnected lookup.
How many ways a relational source definition can be updated and what are they?
What are the tasks that source qualifier perform?
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
How to open an older version of an object in the workspace?
What differs when we choose the sorted input for aggregator transformation?
What are the different options available for update strategy?
Explain how many types of dimensions are available in informatica?
Explain dynamic target flat file name generation in informatica
How do you load only null records into target? Explain through mapping flow.
Explain the different lookup methods used in informatica?
What is difference between a gateway node and worker node?
what is song in infrmatica...?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.