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
Explain what is de-partition in abinitio?
What are the different types of parallelism in ab initio?
How you can run a graph infinitely in ab initio?
What are the types of data processing you are familiar with?
Dear all, Please send me the ab initio pdfs and faqs i need... my mail id is rrajesh.intel@gmail.com
How can we increase the loading performance of oracle table in AbInitio?
Explain the ab initio etl tool in high level?
In abinitio, what types of parallelism are used?
How to replace last 4 digits of an input column with XXXX given input column has 12 digits?
What are the benefits of data processing according to you?
explain checkin and checkout?
What is the max core of a component?
What parallelisms does Abinitio support?
What are the Graph parameter?
What do you mean by the term data warehousing?