How will u remove header record? How will u remove tailer
record?
Answer Posted / anonymouns
if there is a indicator field to differentiate header and
trailer we can use partition by expression component to
remove header and trailer or else use a run program
component to separate out header and trailer and use a join
component to join on all the fields ignore the matching
records, the records coming out of unused ports will be
only body records.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the key elements of a data processing system?
What are the reasons for which business can trust the approach of data processing?
What would be the next step after collecting the data?
I installed AbInito in my PC.In components there is no "select" component.How can i get that component?and How we can create user defined components?
Input A 100 NUll A NUll 200 B 100 Null B Null 300 Output A 100 200 B 100 300 Do this using Ab initio
What do you understand by overflow errors?
What is $mpjret?
Whenever we load data into oracle table from staging table using exchange partition...then I read somewhere that data actually doesn't move in this and this command only reset the pointer in the data dictionary...so if data doesn't move then how data is loaded into the main table ? I mean wat is the point of pointer update in data dictionary?
What is a data processing cycle and what is its significance?
What is the max core of a component?
What metadata importer can do in ab initio?
explain checkin and checkout?
Why might you create a stored procedure with the with recompile option?
What are the facts that can compromise data integrity?
What is a look-up?