Interested to Buy Any Domain ? << Click Here >> for more details...
How will u remove header record? How will u remove tailer
record?
- 5 Answers
- 27890 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
State the relation between EME, GDE and Co-operating system?
What information is provided by .dbc file extension for connecting to the database?
What information does a .dbc file extension provides to connect to the database?
Why might the optimizer use a table scan when an index is available?
When using multiple dml statements to perform a single unit of work, is it preferable to use implicit or explicit transactions, and why?
i have a scenario where i need to change the value of a sort order in my sort component whether ascending or descending depend on some input value... e.g if input_val = A then sort order should be ascending else descending I have to use PDL in this... Can you please tell me where do i have to make this change and how ?
What do you mean by the term data warehousing? Is it different from data mining?
What are the co> operating system’s assorted library of integrated components?
What is is a data flow graph?
What is brodcasting and replicate?
What exactly do you know about the typical data analysis?
You can ask about different vector functions. How to use in abinitio graph?
What are the Types of parallelism in detail?
What would be the next step after collecting the data?
What is the difference between partitioning with key / hash and round robin?
