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 would you find out whether a sql query is using the indices you expect?

689


What are the functions of the replicate and dedup component?

711


Tell us about the architecture of abinitio.

740


Explain the methods to improve performance of a graph?

752


Difference between informatica vs ab initio?

885






Within a cursor, how would you update fields on the row just fetched?

724


How to compare two dmls in abinitio

1355


Why might you create a stored procedure with the with recompile option?

742


Can you explain data flow graph with an example?

819


In abinitio, what types of parallelism are used?

672


What are the kinds of layouts does ab initio supports?

661


Mention what dedup-component and replicate component does?

702


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

708


What are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?

732


Describe the process steps you would perform when defragmenting a data table. Does this table contain mission-critical data?

663