Interested to Buy Any Domain ? << Click Here >> for more details...
In which conditions we can not use joiner transformation
(Limitaions of joiner transformation) ?
- 2 Answers
- 10816 Views
- I also Faced
- E-Mail Answers
Answer Posted / swetha
Both pipelines begin with the same original data source.
Both input pipelines originate from the same Source
Qualifier transformation.
Both input pipelines originate from the same Normalizer
transformation.
Both input pipelines originate from the same Joiner
transformation.
Either input pipelines contains an Update Strategy
transformation.
Either input pipelines contains a connected or unconnected
Sequence Generator transformation.
| Is This Answer Correct ? | 5 Yes | 6 No |
Post New Answer View All Answers
What is expression transformation?
What do you mean by worklet?
Can u generate reports in Informatica?
whats the logic to load the lower level of granularity of data to fact table.
Under what condition selecting sorted input in aggregator may fail the session?
Do you find any difficulty while working with flat files as source and target?
Explain what is informatica metadata and where is it stored?
define galaxy repository in informatica
How would you join a node to the already existing domain?
Explain the difference between a data warehouse and a data mart?
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 diff b/t sorter t/r and agg have the option sorter property...
What is joiner change?
What are ETL Tools?
What does cheating measurement mean?
