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
What do you mean by data sorting?
What do you know about abinitio?
Code check-in and check-out commands in AbInitio
Can you explain data flow graph with an example?
Whenever we load data into oracle table from staging table using exchange partition...then I read somewhere that data actually doesn't move in this and this command only reset the pointer in the data dictionary...so if data doesn't move then how data is loaded into the main table ? I mean wat is the point of pointer update in data dictionary?
What are the functions of the replicate and dedup component?
What do you understand by overflow errors?
What is the function you would use to transfer a string into a decimal?
How transaction file different from that of a sort file?
What is data mapping and data modelling?
What are “business rules” in ab initio business rules environment (bre)?
What is publickey and private key?what is the use of this two keys?
what is the difference between usersandbox,privatesandbox,publicsandbox,commonproject sandbox?
What is the core of co> operating system?
In abinitio, what types of parallelism are used?