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


Please Help Members By Posting Answers For Below Questions

What is "fatal error/rdbms code 3996" error?

966


What are the types of hashed files in data stage

894


what is the custome stage in datastage? how can we impliment that one? plz tell me

2168


What is aggtorec restructure operator?

1128


What are the processing stages?

881


Differentiate between Join, Merge and Lookup stage?

885


what is flow of project?

1778


1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

2035


Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

931


Enlist various types of routines in datastage.

920


How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

3245


What is the sortmerge collector?

928


Differentiate between data file and descriptor file?

831


Explain ibm infosphere information server and highlight its main features?

877


What are the different layers in the information server architecture?

890