How to exclude first and last lines while reading data into a sequential file(having some 1000 records).I guess probably by using unix filter option but not sure which to use
- 6 Answers
- 28781 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / shar
Well if must use filter option in sequential stage then
the Ans is:
head -n 10 'FileName' | tail -n 8
explanation:
suppose if ur file has 10 records + column name then total
lines are 11.
col1
1
2
3
4
5
6
7
8
9
10
head -n 10 will fetch column name + 9 records
and
tail -n 8 will fetch 2 to 9 records excluding colname and
1st record.
like :
2
3
4
5
6
7
8
9
Thats it.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Which algorithm you used for your hashfile?
What is orabulk stage?
What are the various kinds of the hash file?
Distinguish between informatica & datastage. Which one would you choose and why?
What is use Array size in datastage
Describe link sort?
Explain the importance of surrogate key in data warehousing?
What is the different type of jobs in datastage?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
whom do you report?
What are the types of containers and how to create them?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
What is the difference between orabulk and bcp stages?
Differentiate between odbc and drs stage?
If you want to use the same piece of code in different jobs, how will you achieve it?
