Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

I have a source like file it have Number of records and i want to load without first and last records in target?Datastage?

Answer Posted / srinu

using external filter
in this we use command sed -n '1d,
$d'(this is unix command we use we get answer)
(or)
we use command tail +2 |sed -n '$d'

Is This Answer Correct ?    6 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is difference between server jobs & parallel jobs?

1088


Triggers,VIEW,Procedures

1266


In Datastage, how you can fix the truncated data error?

1201


DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks

1581


How to RD using transformer?

1476


sed,awk,head

1501


Explain usage analysis in datastage?

1224


Can you explain players in datastage?

1247


how to add a new records into source?

2055


What is a merge?

1240


What are routines in datastage? Enlist various types of routines.

1154


What is ibm datastage?

1022


What is "fatal error/rdbms code 3996" error?

1343


What are the primary usages of datastage tool?

1128


What are sequencers?

1172