I have a source like file it have Number of records and i want to load without first and last records in target?Datastage?
Answer Posted / srinu
using external filter
in this we use command sed -n '1d,
$d'(this is unix command we use we get answer)
(or)
we use command tail +2 |sed -n '$d'
| Is This Answer Correct ? | 6 Yes | 4 No |
Post New Answer View All Answers
What is difference between server jobs & parallel jobs?
Triggers,VIEW,Procedures
In Datastage, how you can fix the truncated data error?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
How to RD using transformer?
sed,awk,head
Explain usage analysis in datastage?
Can you explain players in datastage?
how to add a new records into source?
What is a merge?
What are routines in datastage? Enlist various types of routines.
What is ibm datastage?
What is "fatal error/rdbms code 3996" error?
What are the primary usages of datastage tool?
What are sequencers?