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
- 7461 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 Symmetric Multiprocessing and Massive Parallel Processing?
How do you import and export data into datastage?
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)
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
How to RD using transformer?
What could be a data source system?
What is the difference between operational data stage (ods) and data warehouse?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
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
What is the use of hoursfromtime() function in transformer stage in datastage?
What are some prerequisites for datastage?
what are the devoleper roles in real time? plz tell i am new to datastage....
How to manage date conversion in Datastage?
what is repositery?
What is data partitioning?
