Wednesday, 9 June 2021

Abinitio Basic Concepts 2021-

 

1 ) what will happen if you specify the commit number as 0? 

Ans - The default value is zero- this means no commit until the component completes execution.

2) Significance of commit number and commit table? 

Ans - A commit table is used to keep track of records committed to a database during execution.
commit number - Number of records per commit checkpoint

3) .profile and .abinitiorc content ?

         Ans - .profile contain -

AB_HOME
AB_AIR_ROOT
AB_CONNECTION
,AB_USERNAME
AB_APPLICATION_HUB
oracle_home 

.abinitiorc contains –  

AB_EME_DATASTORES
AB_NODES
AB_AIR_ROOTS
AB_DISPLAY_NAMES
AB_AIR_HOME
AB_WORK_DIRECTORY
AB_AIR_BRANCHES
AB_AIR_ROOT
AB_CONNECTION
AB_SSH_NEED_PASSWORD
AB_USERNAME 

4) Teradata error code - 12 ? 

Ans - Database ran temporarily out of space, This can occur on an unload when the database runs out of spool space.

-

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

how to create dml dynamically in Ab-initio

 $[ begin let int i = 0; let string(int) complete_list = "emp_nm,billable,age,designation,location"; let string(int) file_content ...

  • Important air commands - Part 1
     1) air tag diff -  ->air tag diff -show-all tag1 tag2 (-show-all -optional list objects for which there are no differences) 2) air tag c...
  • m_dump
    1) How to print records from a file where cust_id started with 1234 by using the m_dump command ? m_dump dml data -select 'starts_with(c...
  • how to create dml dynamically in Ab-initio
     $[ begin let int i = 0; let string(int) complete_list = "emp_nm,billable,age,designation,location"; let string(int) file_content ...