Interested to Buy Any Domain ? << Click Here >> for more details...
How could we generate the sequence of key values without
using sequence generator transformation in the target ??
- 12 Answers
- 37804 Views
- TCS, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / kamalakar
by using pre sql in source qualifier we can generate
sequence in the target
| Is This Answer Correct ? | 16 Yes | 3 No |
Post New Answer View All Answers
What are the different types of repositories created using informatica?
Explain scd type 3 through mapping.
What is the difference between writing a joiner query in ANSI style and THETA style?
In how many ways we can create ports?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
How to start a workflow using pmcmd command?
tell me about your project functionality
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What is the benefit of session partitioning?
What is a rank transform?
How can we use mapping variables in informatica? Where do we use them?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
How many types of sessions are there in informatica.please explain them?
How can repository reports be accessed without sql or other transformations?
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
