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 / 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 |
Post New Answer View All Answers
What are the functions of the replicate and dedup component?
What is the difference between a scan component and a rollup component?
Have you ever encountered an error called “depth not equal”?
What are the Graph parameter?
We know rollup component in abinitio is used to summarize group of data record then why do we use aggregation?
How to execute the graph from start to end stages? Tell me and how to run graph in non-Abinitio system?
How can you SORT an already partitioned (round-robin) data ? How to use in abinitio graph? 3. How internally partition by key decides which key to send in which partition ? How to use in abinitio graph? 4. What is PDL ? Give him a shell type parameter and ask him to convert it to PDL. How to use in abinitio graph? 5. As shell type parameters are not supported by EME, then how you can use shell type parameter (If you don't want to use PDL) without hampering lineage diagram ? How to use in abinitio graph? 6.How you can generate dml from a COBOL copy book ? How to use in abinitio graph? 7. How you can convert from ebcdic to packed decimal ? How to use in abinitio graph?
State the working process of decimal_strip function?
How to add default rules in transformer?
What will be the output when a file with 0 records is connected as input to a reformat and an output file? Note that in reformat we have assigned hardcoded values to output columns.
What do you mean by data sorting?
Mention some file extensions which are used in abinitio?
What is the ab initio business rules environment (bre)?
How to replace last 4 digits of an input column with XXXX given input column has 12 digits?
Mention what is a partition and what are the different types of partition components in abinitio?