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...


insequential file 2header avaliable,and 100 records
avaliable.how to skip the 2 headers and load 100 records
target?

Answers were Sorted based on User's Feedback



insequential file 2header avaliable,and 100 records avaliable.how to skip the 2 headers and load 1..

Answer / riyaz

sed -n '3,100p' filename

Is This Answer Correct ?    8 Yes 0 No

insequential file 2header avaliable,and 100 records avaliable.how to skip the 2 headers and load 1..

Answer / subhash

sed -n '3,100p' filename
or
sed -n '1,2d' filename
Or
tail -98 filename

Is This Answer Correct ?    8 Yes 0 No

insequential file 2header avaliable,and 100 records avaliable.how to skip the 2 headers and load 1..

Answer / manu

By using 'SED'command like this
for header sed -n '1|p’

Is This Answer Correct ?    3 Yes 0 No

insequential file 2header avaliable,and 100 records avaliable.how to skip the 2 headers and load 1..

Answer / venugopal

Using sed command

Is This Answer Correct ?    2 Yes 0 No

insequential file 2header avaliable,and 100 records avaliable.how to skip the 2 headers and load 1..

Answer / sirisha

tail +2

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More Data Stage Interview Questions

wt is the difference between swith and filter stage

6 Answers   IBM,


Have you used Unstructured data?

0 Answers   CTS,


I have file with empid,empname and I want to load these two fields along with sal in my target 1)salary must be same for all the records 2)I want pass the salary at run time

7 Answers   TCS,


create a job to get the previous row salary for the current row.if there is no previous row exists for the current row,then the previous row salary should be displayed as null? empid   salary   previoussalary 10      1000     null 20      2000     1000 30      3000     2000       40      4000     3000

5 Answers   Genpact,


what is a force compile

2 Answers   Cap Gemini, IBM,


How do you schedule or monitoring the job?

0 Answers  


Anyone has Datastage certification free dumps for 000-418 , 000-421 codes, mail me @ manik.dwh@gmail.com 000-418 : InfoSphere DataStage v8.0 000-421 : InfoSphere DataStage v8.5

2 Answers   IBM,


what is use of SDR function?

0 Answers   CGI,


HOW CAN WE SEE THE DATA IN DATASET?

4 Answers  


In one project how many shared containers are created?

3 Answers   NTT Data,


country, state 2 tables r there. in table 1 have cid,cname table2 have sid,sname,cid. i want based on cid which country's having more than 25 states i want to display?

3 Answers   Wipro,


Hi frnds, my scenario is like i'm having a record 1234"1323£3434%343434^23232!1212$23232 in the above record all the special characters must be removed.how can we do it in datastage 8.0.1.can any one please ans this? thanx in advance

2 Answers   IBM,


Categories