Interested to Buy Any Domain ? << Click Here >> for more details...
Without using Lookup & Sequence Generator, How to generate
Sequence?
- 5 Answers
- 14126 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / brahma
using set count varriable in expression transformation.
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
without table how to come first record only in oracle?
How do you load alternate records into different tables through mapping flow?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
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 can you increase the performance in joiner transformation?
Why filter transformation is an active one?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
How might you approve all mappings in the archive all the while?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
Explain sessions. Explain how batches are used to combine executions?
What do you mean by worklet?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
Can we create multiple integration service on single repository?
How union transformation is used?
