How can we count a number of records in a flat file using Abinitio?
Latest Answer: Use rollup component to count the number of record in the flat file.Use {} as key in the key specifier. It will consider all the fields as one record and count the total number of records. ...
How do we use SCD Types in the Abinitio graphs?
What is the order of execution of a graph when it runs?
Latest Answer: 1. Initialisation of Parameters2. Start script execution3. Graph execution4. End script execution ...
How to calculate the total number of records in the file using REFORMAT instead of ROLLUP?
Latest Answer: Connect reformat to log port and use this code and in select parameter specify event_type="finish"type reformat_final_msg = recorddecimal("records") read_count; string("readn") filler_read;decimal("records") written_count; ...
How do we append records to an already existing file usin abinitio graph?
Latest Answer: Create a graph by taking the existing file as the out put file and keep the mode of the output file in Append Mode. Pass the new records from the input file to this output file through a reformat. This will append new records in the existing File. ...
What is output index? How does it work in reformat?Does below function show Output index in useoutput:1:if(in.emp.sal
Latest Answer: Output index function is used in reformat having multiple output ports to direct which record goes to which out port. for eg. for a reformat with 3 out ports such a function could be likeif (value=='A') 1 else if (value=='B') 2 else 3which ...
How does component folding works?
What is the advantage of SORT within GROUP Clause?
Latest Answer: Sort within Groups refines the sorting of data records already sorted according to one key and it sorts the records within the groups formed by the first sort according to a second key. ...
What are environment variable? Why are they required?
Latest Answer: Environment Variables or other wise know as ABINITIO environment variable. Its set in stdenv under which private project and pubic project will be there.Parameters like $AB_HOME , $AB_AIR_RROT will be present in environment variable and this will link ...
What is the need of config variables in abinitio?(ab_job,ab_max_core) and where to define them?
View page [1] 2 3 4 Next >>
Go Top
