Interested to Buy Any Domain ? << Click Here >> for more details...
How will you display "Mr" for male & "Mrs" for female in
target table?
- 7 Answers
- 12647 Views
- I also Faced
- E-Mail Answers
Answer Posted / narinder
Assuming that the source data has some kind of identifier
to track male or female record then use the decode function
based on idetifier to store 'Mr' or 'Mrs' in a port in an
expression transformation and pass this port value to
target.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Have you worked with/created Parameter file
r u done any partitions in ur project?
What do you understand by SOA of Informatica?
What is informatica powercenter repository?
What does update strategy mean, and what are the different option of it?
What is main use of mapplet?
What is the meaning of decode in informatica?
What are the types of data warehouses?
What are active transformations.
Whats the difference between informatica powercenter server, repositoryserver and repository?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
how tokens will generate?
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
Parameter and variable differences
What is a shortcut and copy in Informatica and how two are different with each other?
