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?
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 to read multiple files at different directories using a single Sequential File stage in DS Enterprise Edition
i have a small question for datastage, After the desinging (i.e., transformations and loading)part, what we can do?
How a routine is called in datastage job?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
what is a message handler
CHANGE CAPTURE
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
how to abort the job its matain duplicates?
How do you import and export the datastage jobs?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
input Name Salay Sam 10 Sam 30 Sam 20 Ram 40 Ram 50 Output should be Name Salary Count Sam 10 3 Ram 40 2 get min salary and count of name . OutPut 2 Name Seq Sam 1 Sam 2 Sam 3 Ram 1 Ram 2
my source is sequencial file and my target is dataset. i am running the job in two node configuration file. my source having 10 records how the data move to target?