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
- 7335 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
What is a merge in datastage?
which r the connectors used in san?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
What are the primary usages of datastage tool?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What are the types of containers and how to create them?
What are the different layers in the information server architecture?
how to write server Routine coding?
Where the datastage stored his repository?
What is the difference between odbc and drs stage?
Define meta stage?
What is process model?
What is the process of killing a job in datastage?
