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

What is APT_DUMP_SCORE?

2 Answers   IBM,


What is the difference b/w Hash file and Lookup Fileset stages?

1 Answers  


how can u connect the client system directly at any time?

1 Answers   IBM,


6) my sorce d1 d2 d1 d2 d1 d3 d2 d1 my target tartget 1 d1 2 d1 3 d1 4 d1 target2 1 d2 2 d2 3 d3 Target 3 1 d3 Can any body send me answer this is argent requierment

3 Answers   TCS,


if a column contains data like abc,aaa,xyz,pwe,xok,abc,xyz,abc,pwe,abc,pwe,xok,xyz,xxx,abc, roy,pwe,aaa,xxx,xyz,roy,xok.... how to send the unique data to one source and remaining data to another source????

3 Answers  






What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

0 Answers  


How to reverse the string using SQL?

0 Answers   CTS,


if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

0 Answers   IBM,


Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

0 Answers   CTS,


Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

0 Answers  


how will u design file watch jobs?

2 Answers  


I have a few records all are same structures data, I want to store data in multiple targets how?

4 Answers   Polaris,


Categories