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
How you can fix the truncated data error in datastage?
Define Merge?
What is ds designer?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
What is the difference between Datastage 7.5 and 7.0?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
What is the difference between informatica and datastage?
Describe link sort?
Have you used Unstructured data?
What are the partitioning techniques available in link partitioner?
Can you highlight the main features of ibm infosphere information server?
project Steps,hits, Project level HArd things,Solved methods?
What is size of a transaction and an array means in a datastage?
Differentiate between datastage and informatica?
how can we create rank using datastage?what is the meaning of rank?