Abinitio - Abinitio Display records between 50-75..

GeekInterview.com > Interview Questions > Data Warehousing > Abinitio

Go To First | Previous Question | Next Question

Abinitio | Question 182 of 192

Abinitio Display records between 50-75..

In input dataset i am having 100 records. I want records between 50-75 and i don't want to read 5th record? which component i have to use..

Total Answers and Comments: 3

Last Update: May 11, 2008 Asked by: shylender

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

March 10, 2008 18:43:27

mehta_dipali

Member Since: March 2008 Contribution: 8

RE: Abinitio Display records between 50-75..

I think this can not be done with single component. You can use scan component and assign serial number to all components. Use filter by to display requried records.

Is this answer useful? Yes | No

April 15, 2008 11:02:03

sixto.dsilva

Member Since: March 2008 Contribution: 23

RE: Abinitio Display records between 50-75..

I think you can use the m_dump command to display records between 50-75

m_dump <dml> <mfs file> -start 50 -end 75

hope above command helps.

Is this answer useful? Yes | No

May 11, 2008 13:25:09

njvijay

Member Since: May 2007 Contribution: 10

RE: Abinitio Display records between 50-75..

Another way of doing this is, using next_in_sequence() function and filter by expression component

Is this answer useful? Yes | No

Go To Top