Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sarvesh
just in joiner,go to join condition ,put the condition as
masteroutr join,then u get teh data of matched rows frm
both the tables and unmached rows from master table, tehn u
get the data of master table,then u connceted to tgt table.
this is all i guessing,if it is wrong correct me
| Is This Answer Correct ? | 0 Yes | 10 No |
Post New Answer View All Answers
What is rank transformation?
COM components can be used in Informatica
my source is junk data how will u remove that junk data by using unix please any one replay me
Describe data concatenation?
can we override a native sql query within informatica? How do we do it?
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 the sql query overwrite in source qualifier in informatica
What is the difference between stop and abort in informatica
update strategy transformation in informatica
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
how many types of dimensions are available in informatica?
What is a sequence generator transformation?
What do think which one is the better joiner or look up?
Global and Local shortcuts. Advantages.
Is it possible to create multiple domains on a single Informatica server?
