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
- 12829 Views
- I also Faced
- E-Mail Answers
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 are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?what are differences between different versions of co-op?
What are the differences between different versions of co-op?
How to insert/update a csv file by comparing it with another csv file? for example, i have 2 input files : ColA ColB ColC 1 A AA 2 B AB 3 C CC and second one : ColA ColB ColC 2 B BB 4 D DC Job should compare these 2 files and update the records present in first input file. so the output file will look like this: ColA ColB ColC 1 A AA 2 B BB 3 C CC 4 D DC
Describe the process steps you would perform when defragmenting a data table. Does this table contain mission-critical data?
Pdl with an example?
What is the difference between partitioning with key / hash and round robin?
What is publickey and private key?what is the use of this two keys?
What is a local lookup?
Input Data: AAABBBCC CCAAABB expected output A3B3C2 A3B2C2 How can I achieve this in Ab initio? where In output count of occurrences should be sorted from high to low
How do you improve the performance of a graph?
What are the factors on which storage of data depends?
Why is data processing considered beneficial?
How to move or copy the project parameter or project object to my sandbox?
Mention what dedup-component and replicate component does?
Name any two stages of the data processing cycle and provide your answer in terms of a comparative study of them?
