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
- 9625 Views
- CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / ram
head -3 filename.txt > t1.txt
tail -3 filename.txt > t2.txt
cat filename.txt|sed '3d,$d'|sed '$d'|sed '$d' > t3.txt
| Is This Answer Correct ? | 0 Yes | 0 No |
data stores in which location while using data set stage as the target?
how to retrive the max(sal),deptno,empno in datastage?
how to write server Routine coding?
How many jobs in ur project? Explain any complex job u have done in ur project?
what is A Datastage?
diff between OLTP and OLAP? what TOP-DOWN and BOTTOM-UP Approach? which is best? what are Star Schema and Snow Flake Schema?
what is main difference between change capture and change apply stages
hi this is kiran i have one table i want divide the table with two different table like even rows and odd rows how can i do this one tell me plzz
pls ,tell me good Training centre with Job Oppertunity for Data stage in chennai?
On which Dimension Table you implemented SCD Type in your Project
With out using Funnel Stage, how to populate the data from different sources to single target
What are stage variables and constants?
Teradata 
