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 196

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: 6

Last Update: June 20, 2009 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: 59

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

December 11, 2008 06:34:58

abhi_fresh_as_dew

Member Since: September 2008 Contribution: 12

RE: Abinitio Display records between 50-75..

m_dump is 'THE' best for multiple file system.

For serial and mfs there are many ways the components can be used.

1.Filter by Expression : use next_in_sequence() >50 && next_in_sequence() <75 for 1st requirement and next_in_sequence() ! 5 for 2nd one.

2. We can also use multiple LEADING RECORDS component for meeting the requiremeint.

Abhisek B
fresh as dew!!

Is this answer useful? Yes | No

January 16, 2009 06:31:04

Nayak_AbIntio

Member Since: January 2009 Contribution: 3

RE: Abinitio Display records between 50-75..

If you have the access to Co>Op then you can try an alternate.

Say suppose the input file is : file 1

Use the Run programme component in GDE and write the below command:

`sed -n50 75p file 1 > file 2`

Your file 2 will be the required one.

Is this answer useful? Yes | No

June 20, 2009 04:49:36

idforshivani

Member Since: June 2009 Contribution: 1

RE: Abinitio Display records between 50-75..

You have 100 records You want 50-75.
In UNIX you can use head and tail command

tail - 50f| head -25f

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank