What is meant header and tailer, suppose header and tailer
had some junk data how will delete junk data ? which
components r used?
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 is the importance of eme in abinitio?
How would you find out whether a sql query is using the indices you expect?
How to convert a single column values 1 2 3 4 to single row of 4 columns ? And vice-versa
Mention some file extensions which are used in abinitio?
What are the differences between informatica and abinitio?
What is a rollup component? Explain about it.
What is a look-up?
Describe the evaluation of parameters order in ab initio?
How can a graph be run infinitely?
What kind of layouts does abinitio support?
In abinitio, what types of parallelism are used?
Mention what is rollup component?
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 does de-partition mean in abinitio?
Runtime behavior of Normalize and Reformat