Posts

Showing posts with the label ETL development

S) Header trailer scenario using reformat & lookup

Image
          FBE   Next_in_sequence ==1;   Reformat   output_index_ out : : output_index (in) =   begin     output_index_ out : : if ( next_in_sequence () == lookup_count ( " hh " ) ) 1 else 0;   end ;    

S) How to merge two different column into a single column

Image
input        Output 1 A                1A 2 B               2B 3 C              3C 4 D              4D           Reformat   Out ::reformat (in)=   begin   Out.alfa :: string_concat ( in.id ,in.alfa );   end     Input DML     record   decimal ( "| " )id ;   string ( "\n " ) alfa ;   end     Output DML   re cord   String(“\n ”) alfa ;   end    

T) How to change the version of an existing object in a tag ?

Air tag change-version <tagname> object_name We can pass -version and specific version number as well.

T) Explain about on .abi-unc files in abinitio ?

 These are temporary files used by the checkout process. Under normal circumstances you should not see them. However, if the checkout failed or was interrupted, these files can be left behind. Delete them and try checking out again.    Details: The checkout procedure includes two steps to ensure that a checkout does not leave your sandbox in a half-checked-out state: 1. It checks out the files, but gives them the .abi-unc suffix (for "uncommitted"). 2. Once every file is successfully checked out, the . abi-unc files replace the real files. If an error occurs midway through checkout, any .abi-unc files that have been created might be left behind. If you receive the error message "Cannot write project parameters file: /path/filename.abi-unc" during checkout and you see . abi-unc files, delete them and try checking out again. Uncommitted files are usually left behind because a checkout process was aborted.