Interested to Buy Any Domain ? << Click Here >> for more details...
can v update d records in target using update stargey
without generationg primary key ? explain
- 4 Answers
- 17005 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / leo gilbert
By using "Update override" option in the target. Say the
key of your table is ID,NAME. But your mapping is passing
only ID to the target then you can have an update override
query in the target to update the target only based on
ID.
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
Can informatica load heterogeneous targets from heterogeneous sources?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded 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
What is Data Caches size?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What does update strategy mean, and what are the different option of it?
How are the sources and targets definitions imported in informatica designer?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What is the use of code page?
What are the designer tools for creating transformations?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
How to elaborate tracing level?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What are the limitations of joiner transformation?
