Interested to Buy Any Domain ? << Click Here >> for more details...
suppose if we have dublicate records in a table temp n now
i want to pass unique values to t1 n dublicat values to t2
in single mapping?how
- 4 Answers
- 10826 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / leo gilbert
Have a lookup to table T1 (should be dynamic one). If the
record already exists in T1 (i.e. duplicate) then route to
T2 else route to T1
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
Describe an informatica powercenter?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
scenario where i can use only concurrent execution of workflow.
Explain the informatica workflow?
What do you mean by enterprise data warehousing?
Did u used latest transformations of 8.6.0? for what?
Explain what are the different versions of informatica?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What is a code page?
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
If informatica has its scheduler why using third party scheduler?
How to go to the older version for a mapping?
What is meant by incremental aggregation?
can we override a native sql query within informatica? How do we do it?
What is data transformation manager process?
