Stack Overflow
Stack Overflow

Questions tagged [ab-initio]

The Ab Initio software is a fourth generation data analysis, batch processing, data manipulation graphical user interface (GUI)-based parallel processing product which is commonly used to extract, transform, and load (ETL) data. The Ab Initio product also allows for processing of real-time data.

Ab Initio has a two-tier architecture with a Graphical Development Environment (GDE) and a 'Co>Operating System' coupled together to form a client-server ‘like’ architecture.

The Ab Initio software is a suite of products which together provide a platform for data processing applications. The Core Ab Initio products are:

  • Graphical Development Environment
  • Co>Operating System
  • Enterprise Meta>Environment (EME)
  • Conduct>It
  • The Component Library
  • Data Profiler
  • BRE (Business Rules Environment)

Ab Initio Software Corporation was founded in the mid-1990s by the former CEO of Thinking Machines Corporation, Sheryl Handler, and several other former employees after the bankruptcy of that company.

Source: "Ab Initio Software" article on Wikipedia

91 questions
0
votes
1 answer

Converting a VBA script to Unix script

As a part of Ab Initio Reformat i need to map input fields to output and covert as per there datatype. I wrote a vba script to automate that. PFB Sub reformat() Dim sel As String Dim j As String sel = "" Sheet1.Activate k = Cells(Rows.Count,…
Ankit Srivastava
  • 185
  • 3
  • 13
0
votes
1 answer

Output index for reformat component in abinitio

I have a acct_id and I need to split them to various output files using Segregate the data based on the acct_id mod 1000 value again Please anyone suggest me achieving this.
Shiva kumar
  • 1
  • 1
  • 3
0
votes
1 answer

I want to find the difference between two rows for a column field using fuse in ab initio

I am new in Ab Initio and got stuck in this scenario. TRADEID TRADENAME TRADETYPE AMOUNT 1122 TCS START 2400 1122 TCS CLOSE 2800 I want to find the difference between the amounts ie. 2800 - 2400…
SACHIN KUMAR
  • 9
  • 1
0
votes
2 answers

"m_db unload" command not returning any value in AbInitio

I am using m_db command to load the value from a table to a parameter in AbInitio graph. But its not showing any value. I also run it in Unix but still its not showing any value. The command is (enclosed in back ticks): `m_db unload myoracle.dbc -…
Ravi
  • 182
  • 3
  • 18
0
votes
1 answer

Abintio Record Format- Setting NULL to variable

I have a compoents input record format with a field set to NULL, like, record string(3) INPUT = NULL; end; Comp A -----FlowAtoB---------> Comp B The above record format is the FlowAtoB. I can understand that this sets the value of INPUT to null.…
Harbinger
  • 762
  • 2
  • 14
  • 36
0
votes
1 answer

Ab Initio read multi files component runtime behavior

Does the Ab Initio read multifiles component close files when reading of the file is complete or when reading of all files in the stream is complete? I'm reading in several thousand files and if the RMF component leaves the files open until the…
coffeepac
  • 634
  • 5
  • 13
0
votes
2 answers

Video Tutorials for Ab Initio ETL Data Ware housing Tool !

Please tell me where I can find video tutorials of Ab-Initio ETL Data Ware Housing tool. I surfed in google but i did not find any materials. Thanks in Advance.
Srihari
  • 2,509
  • 5
  • 30
  • 34
0
votes
1 answer

Convert packed decimal to decimal in AB initio

I am having my source data dml as packed decimal data type and i want to reformat it as only decimal data type. eg. original DML :- packed decimal(5,2) Salary Reformated DML:- decimal(",") salary packed decimal(5,2) Salary => decimal(",")…
Pravin
  • 2,871
  • 5
  • 26
  • 29
0
votes
1 answer

Anyone offer a better solution? Right to left regex. using python

First of all happy Independence Day! for those who apply! I´m analyzing an Ab Initio graphs, for that, I need to obtain the name of the component, the one that the developer used to describe it´s functionality, which I can extract from the…
KarTo
  • 98
  • 7
0
votes
3 answers

How to get the values of oracle database parameters from a unix development server?

How to get the fallowing details from the unix development server? The below parameter values should be provided in the .dbc file and it should be mapped to the ETL Server . dbms:
db_version:
db_home:
db_name:
db_nodes:…
Srihari
  • 2,509
  • 5
  • 30
  • 34
0
votes
1 answer

Connecting QlikView With Abinitio and UC4

How can I most efficiently connect AbInitio with QLikView and UC4? I am familiar with the QVX option. Is What ist the interface between these two systems. (Description in German would use me better, but in English is also )
Adam
  • 2,347
  • 12
  • 55
  • 81
0
votes
1 answer

How should I manage the AI in order to prepare promotion and migration of MFS files?

In order to prepare promotion and migration of MFS files, what are your recommendations on managing the AI_MFS parameter? This is often needed in standard promotion of dev>test>prod. It is also needed if the application is migrated to a system using…
Paul Watson
  • 1
  • 1
-1
votes
1 answer

Dead lock issue while inserting data in parallel to oracle table

My job is failing with deadlock. while inserting data in to oracle table in api mode and in parallel. before inset there are updates happening on the table. Since insert operation don't lock any other rows what could be the possible causes for a…
Sai Prasanth
  • 19
  • 1
-1
votes
1 answer

How to apply filter on the data dynamically while reading the filter conditions are available in the master file uploaded by the client

We have a requirement where the client will upload the file with set of rules understandable by the Abinitio. We have to read the rules from the file and need to apply on the dataset dynamically. I have tried uploading the user rules into a table…
Kathula
  • 1
-1
votes
2 answers

Please explain about AbInitio recovery file(.rec)?When should we roll back the file?

Please tell the concept of AbInitio recovery file. When the Abinitio graph fails in execution which cases should we rollback the recovery file and in which cases we shouldnt rollback the recovery file. Please provide links for any AbInitio…
Srihari
  • 2,509
  • 5
  • 30
  • 34
1 2 3 4 5
6
7