write asql query to filter improper date format?
date
20-apr
11-mar-2010
30-may-2010
feb-2009
i want the output
date
11-mar-2010
30-may-2010
- 2 Answers
- 5821 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / prasad
The function appears like this IIF(IS_DATE(DATE, 'DD-MON-YY'),TRUE,FALSE)
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What are the types of presistent cache in look up tr.
Explain the shared cache and re-cache?
How to do unit testing in informatica?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
Where is metadata stored?
What are connected or unconnected transformations?
Where do we use mapping variables in informatica?
my source is junk data how will u remove that junk data by using unix please any one replay me
what is size of u r database?
how to create user defined function (udf) in informatica
What is data movement mode in Informatica and difference between 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 expression transformation?
Reusable transformation and shortcut differences
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
