Hi All, I have a file. i need to fetch the records between
first and last records by using transform stage.
EX:-
Source:
EMPNO EMPNAME
4567 shree
6999 Ram
3265 Venkat
2655 Abhi
3665 Vamsi
5852 Amit
3256 Sagar
3265 Vishnu
Target:
EMPNO EMPNAME
6999 Ram
3265 Venkat
2655 Abhi
3665 Vamsi
5852 Amit
3256 Sagar
I dont wan't to Shree and vishnu records.we can fetch
another way also but How can I write the function in
transform stage?
- 2 Answers
- 6240 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
If data is fetching from SeqFile, we can do this way also
Use Filter Command
Sed '1d;$d' FileName
It will delete frist and last records.
U will get answer, Plz correct me if am wrong....
| Is This Answer Correct ? | 1 Yes | 0 No |
How a server job can be converted to a parallel job?
how can u find out the datastage job is running on how many nodes
How do u view log file for a particular job?
Define ds designer?
How many Nodes configuration file you used in your last project?
Enlist various types of routines in datastage.
What is datastage?
can a fact table contains textual information
6 Answers HCL, HCL BSERV, IBM,
How do you import and export the datastage jobs?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
Can we use sequential file as source to hash file? Have you do it ?if what error it will give?
What is the use of Row generator stage?
Teradata 
