Interested to Buy Any Domain ? << Click Here >> for more details...
without dynamic lookup transformation how to insert new
rows and update existing rows?
- 7 Answers
- 16845 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / vali
you can use source qualifier transformation to do this.
write join condition ...
the rest of the operation will be same
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What is meant by incremental aggregation?
What do you mean by enterprise data warehousing?
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 extract sap data using informatica? What is abap? What are idocs?
What could be the possible resons of locks by user?
Is stop and abort are same in informatica?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
Explain how many types of dimensions are available in informatica?
How do you set a varible in incremental aggregation
What is workflow manager?
can u give example for factless fact table
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What are the different clients of powercenter?
4 yrs etl devloper roles and responsibilities?any body give solutions
