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
When running a stored procedure definition script how would you guarantee the definition could be rolled back in the event of problems?
When we should use 'jobid' for commit table (Output table component?? How to use in abinitio graph?
Explain the ab initio etl tool in high level?
What is the return type of lookup_not_loaded() ? Does it return 0 or 1 to signify true or false or does it return index ...can someone please explain.
I am unable to connect sever database(oracle) from gde(db config file) local system.i set all these?
Suppose we assign you a new project. What would be your initial point and the key steps that you follow?
What is data encoding?
What is rollup component?
What do you know about partition and also tell us about partition components in abinitio?
What is brodcasting and replicate?
What parallelisms does Abinitio support?
What is conduct>it?
What do you understand by a cartesian join?
Explain how abinitio eme is segregated?
Do you think effective communication is necessary for data processing? What is your strength in terms of same?