Interested to Buy Any Domain ? << Click Here >> for more details...
what is diffrence b/w joner and union transfermation
- 6 Answers
- 15626 Views
- I also Faced
- E-Mail Answers
Answer Posted / ashu alle
joiner transformation supports homogenious and
heterogenious data..
union transformation supports only heterogenious data
| Is This Answer Correct ? | 1 Yes | 7 No |
Post New Answer View All Answers
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
How to go to the older version for a mapping?
Do you find any difficulty while working with flat files as source and target?
What is workflow? What are the components of workflow manager?
What is fact table? Explain the different kinds of facts.
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Could you explain what is enterprise data warehouse?
What is sequence generator transformation in informatica?
Plz can any one say me how to get the informatica certification materials and dumps
How you prepared reports for OLAP?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
In informatics server which files are created during the session rums?
On which transformations you created partitions in your project?
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 differentiate between the active and passive transformations?
