How to exclude first and last lines while reading data into a sequential file(having some 1000 records).I guess probably by using unix filter option but not sure which to use
Answer Posted / msbharathi
In sequential file stage use the filter in the options
In filter use sed '1d;$d'
You can use sed '<start>,<end>d' to delete particular rows and use sed -n '<start>,<end>p' to keep particular rows
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Define orabulk and bcp stages?
What is quality stage?
Difference between server jobs & parallel jobs?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
Can you explain kafka connector?
What are the functionalities of link partitioner?
Nls stands for what in datastage?
What is the use of hoursfromtime() function in transformer stage in datastage?
What are some different alternative commands associated with "dsjob"?
Why fact table is in normal form?
What are data elements?
CHANGE CAPTURE
How to reverse the string using SQL?
What is aggtorec restructure operator?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.