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
How would you find out whether a sql query is using the indices you expect?
What are the functions of the replicate and dedup component?
Tell us about the architecture of abinitio.
Explain the methods to improve performance of a graph?
Difference between informatica vs ab initio?
Within a cursor, how would you update fields on the row just fetched?
How to compare two dmls in abinitio
Why might you create a stored procedure with the with recompile option?
Can you explain data flow graph with an example?
In abinitio, what types of parallelism are used?
What are the kinds of layouts does ab initio supports?
Mention what dedup-component and replicate component does?
Describe the elements you would review to ensure multiple scheduled batch jobs do not collide with each other?
What are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?
Describe the process steps you would perform when defragmenting a data table. Does this table contain mission-critical data?