How will u remove header record? How will u remove tailer
record?
- 5 Answers
- 26226 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
Can you explain the performance and scalability of co> operating system?
What are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?
Describe the evaluation of parameters order in ab initio?
What is de-partition in abinitio?
What is a deadlock and how it occurs?
What is the use of the co> operating system in ab initio?
What are the key elements of a data processing system?
What is the difference between formal and export parameter? Export at what secenario we are going to use?
How to replace last 4 digits of an input column with XXXX given input column has 12 digits?
Describe in detail about lookup?
Can sorting and storing be done through single software or you need different for these approaches?
What are the facts that can compromise data integrity?
Suppose we assign you a new project. What would be your initial point and the key steps that you follow?
What are the functions of the replicate and dedup component?
When we should use 'jobid' for commit table (Output table component??
