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 / prasad
In seq file, we have filter option (datastage)
filter= sed '1d;$d'
In Unix= sed '1d;$d' File_Name
it will remove header and footer records(quotes must and should)
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are the different common services in datastage?
How a source file is populated?
what is ds administrator used for?
what are the errors,warnings in datastage
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
In Datastage, how you can fix the truncated data error?
What are the differences between datastage and informatica?
What are the functionalities of link partitioner?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
What is a quality stage in datastage tool?
What are the partitioning techniques available in link partitioner?
What are the stages in datastage?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
What are the types of containers in datastage?
How many Key we can define in remove duplicate stage?