How will u remove header record? How will u remove tailer
record?
Answer Posted / 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 |
Post New Answer View All Answers
When we should use 'jobid' for commit table (Output table component?? How to use in abinitio graph?
What are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?what are differences between different versions of co-op?
How data is processed and what are the fundamentals of this approach?
Explain what is sort component in abinitio?
What are the different types of partition components in abinitio?
What is is a data flow graph?
What is flow buffering ? How it reduces the chances of having deadlock ? How to use in abinitio graph?
What is the difference between formal and export parameter? Export at what secenario we are going to use?
What is the use of the co> operating system in ab initio?
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 is the importance of eme in abinitio?
What kind of layouts does abinitio support?
What exactly do you know about the typical data analysis?
What are the co> operating system’s assorted library of integrated components?
What is the difference between look-up file and look-up, with a relevant example?