Interested to Buy Any Domain ? << Click Here >> for more details...
In update strategy target table or flat file which gives
more performance ? why?
- 7 Answers
- 26274 Views
- I also Faced
- E-Mail Answers
Answer Posted / nagaraju
flat file is better than relational becoz there is no index concet in flat file
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is a stored procedure transformation?
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
Is it possible to use a client with different version than that of its Informatica server?
What is status code in informatica?
Different circumstance which drives informatica server to expel records?
What are the uses of etl tools?
Tell me about MD5 functions in informatica
what is the size of u r source(like file or table)?
What are the components of the workflow manager?
What are the different options available for update strategy?
What is standalone command task?
Is it possible to create multiple domains on a single Informatica server?
How do you load alternate records into different tables through mapping flow?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
Under what condition selecting sorted input in aggregator may fail the session?
