how can we load first and last record from a flat file
source to target?

Answer Posted / sudhar

Alternatively we can use the unix pre session command to
read the 1st and last record from the file and place it in
another file and use that new file as source to load the
target table.

Is This Answer Correct ?    1 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is DR strategy for Informatica project?

938


What is olap (on-line analytical processing?

856


What is meant by a domain?

880


What all are steps in up gradation of Informatica server?

842


What is an expression transformation?

837


tell me 5 session failure in real time how can you solve that in your project?

1913


can any one give some examples for pre sql and post sql(Except dropping and creating index).

3802


If informatica has its scheduler why using third party scheduler?

1038


What does cheating measurement mean?

828


How do you convert single row from source into three rows into target?

896


what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

2073


How to convert multiple rows to single row (multiple columns) in informatica

1155


is it possible to index the data in cache of lkp transformation ?

1764


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

1759


What are the types of schemas we have in data warehouse and what are the difference between them?

750