Answer / aditya kundu

The simplest way to remove header and trailer records is to
use a dedup sorted component using a NULL key. This would
treat the entire record set as a single group. Then use
keep_first and keep_last mode of dedup sorted to select the
header and trailer records.

Another way to accomplish similar result set is using a
ROLLUP component on NULL key. Use the first and last
functions in rollup to select the header and trailer
records.

Answer / dhirendra

There can be many ways to remove header & trailer record
depending on the data you are receiving. If you have a
particular signature for header & Trailer record you can
use Filter by Expression or Partition By Expression
Component to remove the header & Trailer record. If you
don't have signature for your header & Trailer record then
you have to use reformat component to select only the data
record.

Answer / rit

if there is no clue about how the header and trailer would
be then put a filter with next_in_seq = 1 to remove the
header and dedup the whole input with all fields as key and
keep last to remove the trailer.

Answer / anonymouns

if there is a indicator field to differentiate header and
trailer we can use partition by expression component to
remove header and trailer or else use a run program
component to separate out header and trailer and use a join
component to join on all the fields ignore the matching
records, the records coming out of unused ports will be
only body records.

Answer / nag

Yes can be done with the help of REFORMATE component in
this use reformat out put index.if we use this we can get
what ever out we need.

OR
With the help of Run progame compnent.

Explain the methods to improve the performance of a graph?

1 Answers  

What is regex (lookup)? When you should use it?

3 Answers   HCL,

Can any body give me the clear explanation about how to separate header,trailer and body records in Ab Initio?

2 Answers   TCS, Wipro,

Why creation of temporary files depends on the value of MAX CORE ? How to use in abinitio graph? 10. What is the diff between abinitiorc and .abinitiorc files ? How to use in abinitio graph? 11. What is the use of allocate()? How to use in abinitio graph? 12. What is use of branch in EME ? 13. How you can break a lock in EME ? How can you lock a file so that only no one other than EME admin can break it ? How to use in abinitio graph? 14. When you should be using ablocal() ? How you can use ablocal_expr? How to use in abinitio graph? 15. Why you should not keep the layout as 'default' for input table component ? How to use in abinitio graph? 16. What is dynamic lookup ? How to use in abinitio graph? 17. What is dependent parameter ? How to use in abinitio graph? 18. What is BRE ? (Business Rule Environment - This is a recent addition in abinitio package) How to use in abinitio graph? 19.What is output index ? How to use in abinitio graph? 20. How you can track the records those are not getting selected from ‘select’ in reformat component ? How to use in abinitio graph? 21. Can we have more than one launcher process for a particular graph ? How about agent ? How to use in abinitio graph? 22. There are lot of new fuctions added in 2.15 , you can ask about them ? How to use in abinitio graph? 23. How can you run multiple instances of a graph in parallel? How to use

0 Answers   Wipro,

What is the default layout of a component ? Is it mandatory to set the layout of a component ?

3 Answers   IBM,

How to compare two dmls in abinitio

0 Answers  

Explain what is the architecture of abinitio?

0 Answers  

How to implement the funtionality in the custom component to use in the graph?

1 Answers  

How might you quantitatively measure an improvement made to a query?

2 Answers  

can we perform checkin and checkout through sandbox?

0 Answers  

What are the differences between different versions of co-op?

0 Answers  

What is a local lookup?

0 Answers