how to load only the first and last record of a flat file
into the target?
Answer Posted / sanjay gupta
Hi ysr
Can u define the steps please or can u send mapping on my
email id i.e. sanjayguptaa04@gmail.com?
I tried but i am unable to do it..
Thanx in advance
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Can we create multiple integration service on single repository?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What are the different options available for update strategy?
How can we delete duplicate rows from flat files?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What can we do to improve the performance of informatica aggregator 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
what is informatica metadata?
What is the procedure for creating independent data marts from informatica 7.1?
Explain scd type 3 through mapping.
Performance tuning in UNIX for informatica mappings?
What's the layout of parameter file (what does a parameter file contain?)?
What is workflow manager?
What is expression transformation?
Clarify the utilization of aggregator cache record?