Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 13929 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / equalizer
Generally there is a indicator for record type.
For ex If it is Header, the first byte would have H
Trailer,the first byte would have H
Define record types for each using conditional dml and
validate/remove junk data.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / guillermo villarreal
It is very common is DW environments to get source files
with header a trailers. Headers are commonly used to get
the Date of the file and trailers as control with the
number of detail records. Normally you have to make sure
you got the trailer to make sure you haven't received
source files partially
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / nag
In banking and financial modules every file will consists
of Only one header records & Multiple Trailers (Transaction
trailer & Batch trailer.
If it contains junk data we can do it by using Sed Editor
or With help of PERAL SCRIPT.
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / koili basudeba
header and trailer means ...data contains header and trailer
records by using conditional dml or record type header and
trailer.
if i got some junk data in header and trailer ..then first i
separate the header and trailer data by using abinitio
componet like FBE,dedup and reformat then i delete junk
information by using unix command like sed ,awk ..etc
| Is This Answer Correct ? | 0 Yes | 2 No |
what is the output when -1 is put in select_expr of FBE?
Why do you think data processing is important?
How to execute the graph from start to end stages? Tell me and how to run graph in non-Abinitio system?
Have you ever encountered an error called “depth not equal”?
What is local and formal parameter?
What do you mean by continuous graph? what is it significance?
Hi friends if u don't mind i want one question What abt READ MULTIFILE COMPONENT? PLZ GIVE BRIEFLY?
What is meta programming ? Can you generate xfr dynamically? How to use in abinitio graph?
What is the function you would use to transfer a string into a decimal?
Hello, I need help on passing parameter to Oracle Stored Procedure.I am a oracle DBA,need to use some graphs. I need help to pass date parameter with format YYYYMMDD from Ab Initio to Oracle STored Procedure.How to do that please explain me...
)what is wrapper script?where it is going to execute and why we go for wrapper?
What is the difference between In-Memory Sort and Inputs must be sorted?
Teradata 
