Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / gyana
No..its not possible..in repository two operations are
working..one is storing and again retrieving
also..so..storing we can do in flat file but the retrieval
is important that we can't do if u use flatfile as your
repository..
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What are roles and groups and benefits of using them?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
can u give example for factless fact table
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Explain the informatica workflow?
How will the document be delivered to me?
What is DR strategy for Informatica project?
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 sequence generator transformation in informatica?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Suppose we do not group by on any ports of the aggregator what will be the output?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What is the command used to run a batch?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
