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
What are the different types of parallelism in ab initio?
What is the core of co> operating system?
What parallelisms does Abinitio support?
What kind of layouts does abinitio support?
What will be the skew for, input file->partition by key-> partition by round robin->output file
What is a rollup component?
Name any two stages of the data processing cycle and provide your answer in terms of a comparative study of them?
What is sandbox?
What are the factors on which storage of data depends?
Input A 100 NUll A NUll 200 B 100 Null B Null 300 Output A 100 200 B 100 300 Do this using Ab initio
What is broadcasting and replicate?
You can ask about different vector functions. How to use in abinitio graph?
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 ?
How would you find out whether a sql query is using the indices you expect?
Can anyone give me an exaple of realtime start script in the graph?