Whether Aggrigator transformation ignore the null values or
consider the null values ?
Advance Thanks,
Manojkumar
- 3 Answers
- 7689 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / jey.dgl
Yes. Aggregator transformation ignore the null values and In Oracle also ignore the null values.
If u want to ignore the null values, use isnull() function to avoid null values
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
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 happens to map if we alter the datatypes between source and its corresponding source qualifier?
Is it possible to revert a global repository to local one and why?
What do you understand by a term domain?
Slowly changing dimensions, types and where will you use them
Explain the informatica workflow?
Have you worked with/created Parameter file
What you know about transaction control transformation?
How to update a particular record in target with out running whole workflow?
What are the different types of olap? Give an example?
What are some examples of informatica etl programs?
server hot-ws270 is connect to Repository B. What does it mean?
Differentiate between a repository server and a powerhouse?
What is dynamic cache?
expain about the tune parameters?
