What is meant header and tailer, suppose header and tailer
had some junk data how will delete junk data ? which
components r used?
- 5 Answers
- 12382 Views
- I also Faced
- E-Mail Answers
Answer Posted / mahendra patnaik
1. If you know the signature of header and tailer record
then use filerby expression component to filter the header
and tailer records
2. Use one reformate component and then inside the
transformation use next_in_sequence() function to assign
unique numbers to each record,and then use filter by
expression component to filter the records based on
sequence numbers.
3.Follow the step 2 and use instead of filter by expression
component use leading records component to filter the
header and tailer records.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What are the different types of partition components in abinitio?
What are the differences between different versions of co-op?
Pdl with an example?
Why is data processing considered beneficial?
Name any two stages of the data processing cycle and provide your answer in terms of a comparative study of them?
What is the role of co-operating system in abinitio?
How co> operating system natively processes the data?
How transaction file different from that of a sort file?
can we perform checkin and checkout through sandbox?
How to run a graph infinitely?
Describe how you would ensure that database object definitions (tables, indices, constraints, triggers, users, logins, connection options, and server options etc)are consistent and repeatable between multiple database instances (i.e.: A test and production copy of a database)?
To which project that prefix will set is to private project or public project or both?how and where to set?
How do you add default rules in the transformer?
What are the facts that can compromise data integrity?
How does the bre work with the co>operating system?
