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...


How will u remove header record? How will u remove tailer
record?

Answers were Sorted based on User's Feedback



How will u remove header record? How will u remove tailer record?..

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.

Is This Answer Correct ?    12 Yes 1 No

How will u remove header record? How will u remove tailer record?..

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.

Is This Answer Correct ?    14 Yes 4 No

How will u remove header record? How will u remove tailer 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.

Is This Answer Correct ?    5 Yes 5 No

How will u remove header record? How will u remove tailer record?..

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.

Is This Answer Correct ?    0 Yes 0 No

How will u remove header record? How will u remove tailer record?..

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.

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More Ab Initio Interview Questions

How to connect mainframe to Abinitio?

1 Answers   CTS,


We have file having country_name customer_name.For exp London Ram Bangalore Rohit London Shyam Bangalore Abhinav In output we need 2 files one file for london and second file for Bangalore.How to acheve this?

4 Answers   IMS, TCS,


I have a DML in my local system the location is E:/u/home/khaleel/dml how to convert this path to $DML?

1 Answers  


What is brodcasting and replicate?

0 Answers  


What is a data processing cycle and what is its significance?

0 Answers  


What would be the next step after collecting the data?

0 Answers  


Explain data flow graph with an example?

0 Answers  


How to find the project(pub,priv,common,client) in between public, Private,common?Any identification?

0 Answers  


When we should use 'jobid' for commit table (Output table component??

1 Answers   HCL,


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

3 Answers   HCL,


explain the environment varaibles with example?

0 Answers  


What is the difference between In-Memory Sort and Inputs must be sorted?

3 Answers  


Categories