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 the environment varaibles with example?
I am unable to connect sever database(oracle) from gde(db config file) local system.i set all these?
How co>operating system integrates with legacy codes?
How to move or copy the project parameter or project object to my sandbox?
What is sort component in abinitio?
We know rollup component in abinitio is used to summarize group of data record then why do we use aggregation?
Mention what are the different types of parallelism used in abinitio?
Mention what the difference between “look-up” file and “look is up” in abinitio?
What is a local lookup?
Hi friends, what are the new features in abinito3.0?
Describe how you would ensure that database object definitions (tables, indices, constraints, triggers, users, logins, connection options, and server options etc)are consistent and repeatable between multiple database instances (i.e.: A test and production copy of a database)?
Can anyone give me an example of realtime start script in the graph?
What do you mean by a transaction file and how it is different from that of a sort file?
What the difference between “look-up” file and “look is up” in abinitio?
Dear all, Please send me the ab initio pdfs and faqs i need... my mail id is rrajesh.intel@gmail.com