Interested to Buy Any Domain ? << Click Here >> for more details...
WHAT IS THE NAME OF THAT PORT IN DYNAMIC CACHE WHICH IS USED
FOR INSERT , UPDATE OPRATION ?
- 4 Answers
- 13848 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / bsgsr
u mean inserting and updating the source records into the
cache. then the answer shud be insert else update which
lies below dynamic lookup port.
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
Explain lookup transformation source types in informatica
where to store informatica rejected data?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What is Cognos script editor?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
what is the hint? how to use it to reduce the query processing in program?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
How can we use batches?
Whats there in global repository
Can you generate sequence numbers without using the sequence generator transformation?
How can repository reports be accessed without sql or other transformations?
What is the difference between STOP and ABORT options in Workflow Monitor?
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
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
where to store informatica rejected data? How to extract the informatica rejected data?
