Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / prasad
Transformation is a power center object which allows you to
define a business logic for processing the data or
converting the data one format to another format.
two types: active and passive
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is a mapplet/worklet in informatica?
Explain lookup transformation is active in informatica
Sequence generator, when you move from develoment to production how will you reset
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
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
How can you generate reports in informatica?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What does cheating measurement mean?
Why is sorter an active transformation?
What is decode in static cache?
How can you validate all mappings in the repository simultaneously?
What is a shortcut and copy in Informatica and how two are different with each other?
How you prepared reports for OLAP?
How to generate sequence numbers using expression transformation?
What is sequence generator transformation in informatica?
