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 / prasad

In seq file, we have filter option (datastage)

filter= sed '1d;$d'

In Unix= sed '1d;$d' File_Name

it will remove header and footer records(quotes must and should)

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different common services in datastage?

1291


How a source file is populated?

1071


what is ds administrator used for?

1175


what are the errors,warnings in datastage

2705


hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

1873


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

1164


What are the differences between datastage and informatica?

1181


What are the functionalities of link partitioner?

1023


Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

2225


What is a quality stage in datastage tool?

1082


What are the partitioning techniques available in link partitioner?

2280


What are the stages in datastage?

1086


Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

781


What are the types of containers in datastage?

1193


How many Key we can define in remove duplicate stage?

1391