Friday, 24 September 2021

Abinitio - Transform Function (Rollup,Scan,Join,Reformat,)

 Rollup - 






Scan - 



Join - 



When Join Type is explicit - 




 



-

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 ...