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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How is the partitioning with key different from round robin partition?

633


What is $mpjret?

655


Describe the elements you would review to ensure multiple scheduled batch jobs do not collide with each other?

594


Give one reason when you need to consider multiple data processing?

604


Can you explain the performance and scalability of co> operating system?

607






Explain the difference between the truncate and delete commands?

589


How can you import XML repositories exported from different tools like ODI

3022


What is the difference between a scan component and a rollup component?

581


We know rollup component in abinitio is used to summarize a group of data record then why do we use aggregation?

762


How to execute the graph from start to end stages? Tell me and how to run graph in non-Abinitio system?

703


What do you know about partition and also tell us about partition components in abinitio?

572


What do you understand by local lookup?

632


How can you SORT an already partitioned (round-robin) data ? How to use in abinitio graph? 3. How internally partition by key decides which key to send in which partition ? How to use in abinitio graph? 4. What is PDL ? Give him a shell type parameter and ask him to convert it to PDL. How to use in abinitio graph? 5. As shell type parameters are not supported by EME, then how you can use shell type parameter (If you don't want to use PDL) without hampering lineage diagram ? How to use in abinitio graph? 6.How you can generate dml from a COBOL copy book ? How to use in abinitio graph? 7. How you can convert from ebcdic to packed decimal ? How to use in abinitio graph?

3859


What happens when we provide null key to sort, merge and pbks in Abinitio ?

793


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

546