Interested to Buy Any Domain ? << Click Here >> for more details...
What are two types of processes that informatica runs the
session?
- 2 Answers
- 19119 Views
- I also Faced
- E-Mail Answers
Answer Posted / swetha
Load manager Process: Starts the session, creates the DTM
process, and sends post-session email when the session
completes.
The DTM process. Creates threads to initialize the session,
read, write, and transform data, and handle pre- and
post-session operations.
| Is This Answer Correct ? | 16 Yes | 2 No |
Post New Answer View All Answers
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How to generate sequence numbers using expression transformation?
What are session parameters ? How do you set them?
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
What is the meaning of up gradation of repository?
Repository user profiles
What is DR strategy for Informatica project?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
Tell me about MD5 functions in informatica
What is an expression transformation in informatica?
What are the static cache and dynamic cache in informatica?
What is workflow? What are the components of workflow manager?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What are Dimensional table?
What are the different lookup cache(s)?
