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
- 9626 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
Difference between server jobs & parallel jobs?
Define Data Stage?
On which interface you will be working as a developer?
What are the different options associated with dsjob command?
What is oci?
Demonstrate experience in maintaining quality process standards?
Distinguish between informatica & datastage. Which one would you choose and why?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
Whats difference betweeen operational data stage (ods) and data warehouse?
How do you import and export data into datastage?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
What are datastage sequences?
What are system variables and sequencers in datastage
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
