How will u remove header record? How will u remove tailer
record?
Answer Posted / rit
if there is no clue about how the header and trailer would
be then put a filter with next_in_seq = 1 to remove the
header and dedup the whole input with all fields as key and
keep last to remove the trailer.
| Is This Answer Correct ? | 5 Yes | 5 No |
Post New Answer View All Answers
How to move or copy the project parameter or project object to my sandbox?
Whenever we load data into oracle table from staging table using exchange partition...then I read somewhere that data actually doesn't move in this and this command only reset the pointer in the data dictionary...so if data doesn't move then how data is loaded into the main table ? I mean wat is the point of pointer update in data dictionary?
When we should use 'jobid' for commit table (Output table component??
How scientific data processing is different from commercial data processing?
How do you improve the performance of a graph?
Within a cursor, how would you update fields on the row just fetched?
What is is a data flow graph?
When we should use 'jobid' for commit table (Output table component?? How to use in abinitio graph?
You can ask about different vector functions. How to use in abinitio graph?
explain checkin and checkout?
In abinitio, what types of parallelism are used?
Runtime behavior of Normalize and Reformat
can we perform checkin and checkout through sandbox?
Describe the process steps you would perform when defragmenting a data table. This table contains mission critical data?
What is the difference between formal and export parameter? Export at what secenario we are going to use?