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

How you can fix the truncated data error in datastage?

1683


Define Merge?

1267


What is ds designer?

1036


1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

1971


What is the difference between Datastage 7.5 and 7.0?

1058


how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

2139


What is the difference between informatica and datastage?

1154


Describe link sort?

967


Have you used Unstructured data?

1273


What are the partitioning techniques available in link partitioner?

2235


Can you highlight the main features of ibm infosphere information server?

1050


project Steps,hits, Project level HArd things,Solved methods?

2071


What is size of a transaction and an array means in a datastage?

1247


Differentiate between datastage and informatica?

1146


how can we create rank using datastage?what is the meaning of rank?

8714