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
- 9650 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
How do you schedule or monitoring the job?
Triggers,VIEW,Procedures
Define ds designer?
What is the difference between hashfile and sequential file?
Define Data Stage?
What all are the different way to run a job?
What are the various kinds of the hash file?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
What is a datastage job?
What are the areas of application?
Can you explain tagbatch restructure operator?
Define Job control?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
Can you explain how could anyone drop the index before loading the data in target in datastage?
How and where you used hash file?
