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
EXPLAIN SCD
What is the process of killing a job in datastage?
Can you explain how could anyone drop the index before loading the data in target in datastage?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
how to write server Routine coding?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
What are the steps required to kill the job in Datastage?
CHANGE CAPTURE
How to convert RGB Value to Hexadecimal values in datastage?
What is a quality stage in datastage tool?
What are the areas of application?
Difference between sequential file and data set?
What is the difference between hashfile and sequential file?
Can you implement SCD2 using join, transformer and funnel stage?
Difference between data warehousing and olap?