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
Describe what the SQL Server tempdb and tlog files are used for?
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?
How co> operating system natively processes the data?
Code check-in and check-out commands in AbInitio
What is the use of aggregation when we have rollup as we know rollup component in abinitio is used to summarize a group of data record? Then where we will use aggregation?
What are the factors on which storage of data depends?
How to find the project(pub,priv,common,client) in between public, Private,common?Any identification?
Within a cursor, how would you update fields on the row just fetched?
how will i can implement Insert a new record (if not present in Input file),Update the record (if present in input) a csv file in Abinitio
Can you explain the co>operating system’s processing model?
When we should use 'jobid' for commit table (Output table component??
How to compare two dmls in abinitio
Why is data processing considered beneficial?
What is the difference between look-up file and look-up, with a relevant example?
Define ramp limit in ab initio?