in unconnected lookup , what are the other transformations ,
that can be used in place of that expression transformation ?
- 9 Answers
- 19210 Views
- Target, I also Faced
- E-Mail Answers
Answer Posted / sid
I think we can use agg t/f and rank t/f for this
we cant use filter ,update strategy t/f becoz in these two
we wright the condition in conditions tab but not in ports .
| Is This Answer Correct ? | 4 Yes | 6 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
How to join three sources using joiner?
How many types of sessions are there in informatica.please explain them?
In informatica workflow manager, how many repositories can be created?
difference between informatica 8.1.1 and 8.6
What is different between the data warehouse and data mart?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What do you mean by enterprise data warehousing?
What is workflow monitor?
What is a router transformation?
what are factless facts? And in which scenario will you use such kinds of fact tables.
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
Define enterprise data warehousing?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
my source is junk data how will u remove that junk data by using unix please any one replay me
