How will u remove header record? How will u remove tailer
record?
- 5 Answers
- 26773 Views
- EDS, Polaris, I also Faced
- E-Mail Answers
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
Mention what the difference between “look-up” file and “look is up” in abinitio?
What does edp stand for?
Name any two stages of the data processing cycle and provide your answer in terms of a comparative study of them?
How to find the project(pub,priv,common,client) in between public, Private,common?Any identification?
What is the use of aggregation when we have rollup as we know rollup component in abinitio is used to summarize a group of data record? Then where we will use aggregation?
Why do you think data processing is important?
Mention what is the syntax for m_dump in abinitio?
Mention what information does a .dbc file extension provides to connect to the database?
What do you understand by local lookup?
How to compare two dmls in abinitio
What is rollup component?
What is broadcasting and replicate?
Explain PDL with an example?
Have you used rollup component? Describe how.
To which project that prefix will set is to private project or public project or both?how and where to set?
