Interested to Buy Any Domain ? << Click Here >> for more details...
How will u remove header record? How will u remove tailer
record?
- 5 Answers
- 27911 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
What are the Types of parallelism in detail?
explain checkin and checkout?
Can sorting and storing be done through single software or you need different for these approaches?
Mention what information does a .dbc file extension provides to connect to the database?
What are the key elements of a data processing system?
What do you know about partition and also tell us about partition components in abinitio?
Explain PDL with an example?
Why do you think data processing is important?
What is $mpjret?
What is MAX CORE of a component?
What is the return type of lookup_not_loaded() ? Does it return 0 or 1 to signify true or false or does it return index ...can someone please explain.
Why might you create a stored procedure with the with recompile option?
What are the functions of the replicate and dedup component?
What are the benefits of data processing according to you?
Mention what is the syntax for m_dump in abinitio?
