How informatica process data means how informatica works?

Answer Posted / shalaka kulkarni

When work flow starts integration service retrieve mapping ,workflow ,and session form repository,It extract data from mapping sources and store in staging area apply transformation logic .then load it into target according to requirement. For that it uses three components:
Integration service process
Load balancer
DTM process

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you load first and last records into target table?

946


Explain the types of transformations?

832


What is the function of union transformation?

872


What are the various types of transformation?

915


How can we create index after completion of load process?

855


What is an Integration service in Informatica?

918


What are the types of caches in lookup?

801


What is substr in informatica?

917


Does an informatica transformation support only aggregate expressions?

831


What is powercenter on grid?

962


Explain scd type 3 through mapping.

783


How do you load only null records into target?

988


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

1757


What does cheating measurement mean?

828


What does “tail –f” command do and what is its use as an Informatica admin.

866