Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

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?

Question Posted / shreeram gundu

Answers were Sorted based on User's Feedback



Hi All, I have a file. i need to fetch the records between first and last records by using transfo..

Answer / subhash

In the transformer stage's link constraints:
write below constraint
@INROWNUM <> 1 And @INROWNUM <> LastRow()
then you will get the desired out put.

Is This Answer Correct ?    5 Yes 1 No

Hi All, I have a file. i need to fetch the records between first and last records by using transfo..

Answer / 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

More Data Stage Interview Questions

Hi Vijay here For Four CPU's how many nodes will required?

4 Answers   TCS,

in job of 30 one job is very slow due to this entire job is very slow how can u know which job is slow?

0 Answers   IBM,

How do u view log file for a particular job?

6 Answers   HP,

What is audit table?

1 Answers  

What steps should be taken to improve Datastage jobs?

0 Answers  

what is the use of surogate key in datastage

3 Answers  

WHAT ARE THE STAGES U WILL USE IN IMPLEMENTING SCD2/DATE FIELD

8 Answers   L&T,

What is RCP

5 Answers   CGI, CTS,

in one scenario source flat file like Fileld1 00122001550056200568 00256002360014500896 00123004560078900258 00147004560025800256 divide each 5 numbers as one column i.e here i need field1 field2 field3 field4 00122 00155 00562 00568 00256 00236 00145 00896 00123 00456 00789 00258 00147 00456 00258 00256 plz help me....

4 Answers  

souce file having the columns like name company krish IBM pooja TCS nandini WIPRO krish IBM pooja TCS if first row will be repeat i want the result like this name company count krish IBM 1 pooja TCS 1 nandini WIPRO 1 krish IBM 2 pooja TCS 2

9 Answers  

Is there any possibility to generate alphanumeric surrogate key?

3 Answers   ABC, IBM,

What is the roundrobin collector?

0 Answers  

For more Data Stage Interview Questions Click Here
Categories