What are the out put files that the informatica server
creates during the session running?
Answer Posted / guest
session log files
workflow log files
Cache files;created and deleted at the end of session.
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
Can we create a Integration service without a Repository service and vice versa?
What are the types of presistent cache in look up tr.
Differences between connected and unconnected lookup?
How to implement security measures using repository manager?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
Whats there in global repository
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
Explain informatica architecture - version 8 / 9
What is the session task and command task?
Explain pushdown optimization and types in informatica
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
How can repository reports be accessed without sql or other transformations?
How do you manage the Parameter files while migrating your data from one environment to another environment?
How do you load alternate records into different tables through mapping flow?
Explain the tuning lookup transformation - informatica