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
- 9204 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
Give an idea of system variables.
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
CHANGE CAPTURE
How do you remove duplicate values in datastage?
how many rows sorted in sort stage by default in server jobs
What are the types of containers in datastage?
How we can covert server job to a parallel job?
what is the custome stage in datastage? how can we impliment that one? plz tell me
What is the difference between account and directory options ?
Define Routines and their types?
How do you run datastage job from the command line?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
project Steps,hits, Project level HArd things,Solved methods?
What are the repository tables 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?
