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?
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
Can you explain players in datastage?
On which interface you will be working as a developer?
Define data aggregation?
what are the errors,warnings in datastage
sed,awk,head
How and where you used hash file?
How to read multiple files using a single datastage job if files have the same metadata?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
What are some different alternative commands associated with "dsjob"?
How to find value from a column in a dataset?
What are the differences between datastage and informatica?
What steps should be taken to improve Datastage jobs?
Why fact table is in normal form?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
what is the use of materialized view?