Interested to Buy Any Domain ? << Click Here >> for more details...
This is UNIX question asked in DataStage Interview.
Say I have n numbers of records in a text file.
I want first 3 records in 1st file, last three records in 3rd file and remaining n-6 records in 2nd file.
(Note: we don't know how many records are there in the File. I am getting one file on daily basis and I want three target files as asked above)
- 2 Answers
- 9729 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / reddy
First check the filename how many records are there
wc -l finename
it will give count
then first check the filename if it has header and footer
If not use below unix commands
when we use wc -l filename, it will give count, for example we have 1000 records
Ans1: Head -3 filename.txt >Target1.txt
Ans2: Tail -3 filename.txt >Target3.txt
Ans3: sed -n '4,997p' filename >Target2.txt
Please correct me if i am wrong....
| Is This Answer Correct ? | 13 Yes | 1 No |
Post New Answer View All Answers
Describe the main features of datastage?
What is the purpose of pivot stage and types of containers in datastage
Why do we use exception activity in Datastage?
what is repositery?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
How do you generate sequence number in datastage?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
What are the different type of jobs in datastage?
How a server job can be converted to a parallel job?
Nls stands for what in datastage?
What is use Array size in datastage
What are the repository tables in datastage?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
Explain entity, attribute and relationship in datastage?
What are the enhancements made in datastage 7.5 compare with 7.0?
