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
What is "fatal error/rdbms code 3996" error?
What are the types of hashed files in data stage
what is the custome stage in datastage? how can we impliment that one? plz tell me
What is aggtorec restructure operator?
What are the processing stages?
Differentiate between Join, Merge and Lookup stage?
what is flow of project?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
Enlist various types of routines in datastage.
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
What is the sortmerge collector?
Differentiate between data file and descriptor file?
Explain ibm infosphere information server and highlight its main features?
What are the different layers in the information server architecture?