Want to know about Training Centres for Informatica, Cognos
and ETL Softwares in Mumbai, India.
- 27 Answers
- 41363 Views
- I also Faced
- E-Mail Answers
Answer Posted / satish
I did my training through one private trainer he is
contactable at
09221985450
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
What is a dimensional model?
What is the cumulative sum and moving sum?
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
Difference between Target-based loading and constraint-based loading?
Can we create two repositories on same database instance in oracle?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
How can we use batches?
Where can we find the throughput option in informatica?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What is data transformation manager process?
What are the various types of transformation?
Write the advantages of partitioning a session?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Explain scd type 3 through mapping.
