Interested to Buy Any Domain ? << Click Here >> for more details...
in my lookup table i want to catch the recently updated
records from the source to target,how to achieve this and what
is last commit interval point for this?
- 2 Answers
- 6948 Views
- Thomson Reuters, I also Faced
- E-Mail Answers
Answer Posted / prasanna
BY using dynamic lookup cache it is possible
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What is a sequence generator transformation?
What do you mean incremental aggregation?
How do you remove duplicate records in informatica? And how many ways are there to do it?
What is flashback table ? Advance thanks
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What is the commit type if you have a transaction control transformation in the mapping?
What is an aggregator transformation?
What are the reusable 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
what is the -ve test case in your project.
What is the format of informatica objects in a repository?
What are the types of caches in lookup? Explain them.
Is it possible to use a client with different version than that of its Informatica server?
Informatica settings are available in which file?
How to join three sources using joiner? Explain though mapping flow.
