Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7229 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / reddymkl.dwh
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 |
Post New Answer View All Answers
Differentiate between data file and descriptor file?
Define project in datastage?
What are the main differences you have observed between 7.x and 8.x version of datastage?
Can you define merge?
What are the primary usages of datastage tool?
Give an idea of system variables.
How you Implemented SCD Type 1 & Type 2 in your project?
Difference between in process and inter process?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
Define APT_CONFIG in Datastage?
Which algorithm you used for your hashfile?
What are the main features of datastage?
What is the difference between account and directory options ?
How to perform incremental load in datastage?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
