Abinitio Interview Questions 28 Abinitiorc Files


Abinitio Interview Questions 28 Abinitiorc Files




Watch my YouTube video for explanation :

                        


What are the different abinitiorc files

   30.1  Global Abitiorc file /etc/abinitio/abinbitiorc
   
   
    At the level of host and it is accessible for all installation under the same host
   
        a. its an optional abinitiorc file 
b. it is global in nature as its declaration impacts all installation done under the host
c. the variable of this can not be overridden
d. can use include statement in this config file
Use cases:
AB_CHARSET
AB_OUTPUT_FILE_UMASK
UNIX
Windows
Super User(Admin)
   
        
   
   30.2. Server installation specific abinitiorc file $AB_HOME/config/abinitiorc
   
used for specific server and all users under the sever
 
a. Main configuration file for an individual cop installation
b. Generatd when installation done
c. Affects all users who uses that installation under the host
 
Use case
a. Setting up directory for temporary files - AB_WORK_DIR, AB_DATA_DIR etc
b. Setting up cross computer access 
c. Setting Character set
 
   
   30.3  User specific abinitiorc file $AB_HOME/.abinitiorc
    
     Specific to a sandbox or generic sandbox user
 
a. a value set in user abinitorc file takes precedence over $AB_HOME/config/abinitiorc
b. a value set in user abinitiorc file does not take precedence over global abinitiorc file



For more Abinitio, AWS and data engineering videos please subscribe , view , like and share my YouTube channel 

Click DataPundit

 

Comments

Post a Comment

Popular posts from this blog

Abinitio Interview Question # 1 - Write Multiple Files in Abinitio

Image
 Question :  I get records of various region in huge volume ,  we want to write the records in region specific files.   How to achieve that? View the explanation in the below video: Answer: -WMF WMF: filename::get_filename(in)= begin let string("") l_filename=string_substring(in.data.region); filename::string_concat($AI_SERIAL,"/",l_filename.dat); end; out::reformat(in)= begin out::in.data; end; OUTPUT DML-: DML record string(int) filename; string(integer(4)) file_contents; end; RMF: filename::get_filename(in)= begin filename::string_concat($AI_SERIAL,"/",in.filename); end; out::reformat(read,filename,in)= begin out.file_contents::read; out.filename::filename; end; Please view my youtube channel  DataPundit
Read more
Image
  Metaprogramming in Abinitio 1. How to create output DML dynamically based in INPUT DML 2. How to create intermediate transform( XFR) dynamically based on INPUT DML      Please See my you tube video for explanation : PART 1 PART 2 For Example, let us say, we have an Input DML as below-: cat input.dml record string(",") name; decimal(",") age; decimal(",") salary; string(",") aadharid; date("yyyy-mm-dd")(",") joiningdate; string(",") mobileno=NULL; string(",") dlno=NULL; string(",") passportnumber=NULL; end; (1.1) prepare a new DML based on input DML i.e. add fields, remove fields, modify type Graph based parameters: ===================================================================== input_dml=$DIR/input.dml  [interpretation = constant] input_dml_info =$[read_type(input_dml)]   [interpretation = pdl] /* Define functions in AB_DML_DEFS */ AB_DML_DEFS= $[ out:: dynamic_dml_gen(input_dml_info)= beg...
Read more

Next In Sequence in ABinitio | How next_in_sequence() works in MFS

Image
https://youtu.be/JdDDpjZcv-4 next_in_sequence() working in Abinitio: Definition -      within a single process(component) , this gives successive number.   next_in_sequence()>1 i.e. all records whose occurance is 2 and more in the file.      for example dataset below:    employeeName ram shyam ravi hanuman shekhar seeta geeta shayama vidushi vishakha If we process by condition next_in_sequence()>1 then the output will be [first record will be removed] shyam ravi hanuman shekhar seeta geeta shayama vidushi vishakha 2. next_in_sequence() with reformat  - rely -  FieldA 1a 2a 3a 4a 5a 6a 7a Example 1 (serial processing)--> Reformat   count=2      select:   next_in_sequence()<900      Transofom1:   out:reformat(in)=   begin   out.*::in.*;   out.Seq-No::next_in_sequence();   end;      Transform2:   out:reformat(in)=   begin   out.*:...
Read more