insequential file 2header avaliable,and 100 records
avaliable.how to skip the 2 headers and load 100 records
target?
Answer Posted / riyaz
sed -n '3,100p' filename
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What is the difference between informatica and datastage?
How you Implemented SCD Type 1 & Type 2 in your project?
What is difference between symmetric multiprocessing and massive parallel processing?
Define orabulk and bcp stages?
What is the differentiate between data file and descriptor file?
What is a merge in datastage?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
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)
What is aggtorec restructure operator?
Define repository tables in datastage?
What are the functionalities of link partitioner and link collector?
Can you explain link buffering?
How to convert RGB Value to Hexadecimal values in datastage?
How will you move hashed file from one location to another location?
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