Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / swetha
Two ways
1.Drag the port from another transforamtion
2.Click the add buttion on the ports tab.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
How can we create index after completion of load process?
draw informatica architecture 8.6 ?
What do you mean incremental aggregation?
Name the different lookup cache(s)?
what is $$$$?
Write the prerequisite tasks to achieve the session partition?
How you prepared reports for OLAP?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What is the use of source qualifier?
What is the use of target designer?
How do you set a varible in incremental aggregation
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?
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 mapplet in informatica?
What is informatica etl tool?
