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

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

0 Answers   CTS,

is it possible to access the same job by two users at a time in DataStage?

2 Answers   IBM,

What is ds designer?

0 Answers  

What is the difference between Datastage 7.5 and 7.0?

0 Answers  

What is difference between server jobs & parallel jobs?

0 Answers  

where we use column generator stage in real time scenario?

5 Answers   TCS,

1)How to do error handling in datastage? 2)Did sequential stage accepts .xl files ,xml? znd how?

2 Answers   UHG,

how do you pass parameters in a script?

1 Answers   L&T,

tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

0 Answers   IBM,

Is it possible to query a hash file?

0 Answers   IBM,

if ename='subbu' while running job the job should be abort how come?

3 Answers   IBM,

I have a source like file it have Number of records and i want to load without first and last records in target?Datastage?

4 Answers   CSC,

For more Data Stage Interview Questions Click Here
Categories