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

Abinitio configuration file in AWS

We have a Abinitio graph in On-prem, which relies on a configuration file to get few key inputs. To migrate this graph to AWS, we are looking for a better way to handle this configuration info. This configuration info will be setup one time and it…
Prakash
  • 1
  • 2
0
votes
2 answers

I am trying to write an expression where it would give the below output in Abinitio GDE

input in zero byte file made in unix: 2000560|Bibek|28 3490679|kjdsk|56 1775679|Samrat|45 my output needed is Bi kj Sa
Samrat Saha
  • 1
  • 1
0
votes
0 answers

Level of operators in a Tree structure made by two columns

so I'm working in the Ab Initio GDE and got a specific set of IDs in different columns, that if I put them together should equal the levels of a tree structure. the two columns are as follows: enter image description here Both IDs describe operators…
Ene
  • 1
0
votes
0 answers

Database configuration file

I want to fetch data from mysql but I don't have the .dbc file yet do you guys know how to create db configuration file in abinitio to access mysql database?
Divim
  • 1
0
votes
1 answer

Testing several data validation graphs developed in Ab Initio environment

How to test data validation graphs developed in Ab Initio environment ? Can someone explain as am new to this or give links to resources where I can learn more about it ?
Aizahs Afreen
  • 1
0
votes
1 answer

ABinitio- how to get/return first not null column from a list of columns

I am new to ABinitio, need help : I have 6 columns with address fields , trying to find function in Abinitio which returns first not null value taking list of columns as arguments(something similar to Coalesce in Teradata or NVL in Oracle) my…
Shirin BS
  • 11
  • 1
0
votes
1 answer

Is there a way to schedule AbInitio Graph using an input pset with cron?

Pretty much as the title implies. With an AbInitio Graph, is there a way to use a cron expression in an input pset? What would need to be set up for the cron expression to be recognized and kick off the process?
JYosen
  • 89
  • 7
0
votes
1 answer

SEQUENCE AB INITIO

I want to create a field "folio" that is a sequence type: seq-1 seq-2 .. seq-n and that each time I execute my work that page starts from the last one before seq-n+1 seq-n+2 .. etc. I used "seq- + next_in_sequence()" but I can't get it to continue…
KLM
  • 51
  • 1
  • 8
0
votes
1 answer

Where is Abinitio configuration for ETL is stored?

There are about 200+ Abinitio ETL configurations that I have. I would like to know where the ETL configurations are stored. Abinition is installed in linux box, I could access the DML configuration which just lists the fields and the corresponding…
madmatrix
  • 205
  • 1
  • 4
  • 12
0
votes
2 answers

How to read a file which is having delimiter in the field values enclosed with double quotes in AbInitio

I have a .dat file which is delimited by a pipe (|). Now my columns can have | in the data. I am facing issues while reading this file and loading it column by column. DML used: record string("|") col1, string("|") col2, string("|")…
akansha pandey
  • 1
  • 2
0
votes
1 answer

How to send email when input query Salesforce object component(postgresql) fetching or output table (mssql) unloading zero record or empty records

In an existing graph I wanted to have a check on any one of the query Salesforce object component or output table component weather it is writting or unloading zero records and i wanted get notified by email about the same. What will be the better…
Nat-khat Umi
  • 1
  • 1
0
votes
1 answer

Is there a way to handle comma separated data in a particular column in Abinitio

I do have a source team data sent as below: Name ID StateCode Abc 1 CA,GE Xyz 2 IL,MA As you can see the StateCode column has again comma separated values. Can anyone suggest how can the above records read in Ab Initio? Name and ID are…
MN1691
  • 1
  • 1
0
votes
1 answer

Creating zero record parquet file using ab initio write HDFS component

There is a requirement where I have to create a zero record parquet file. I have attached input table component to write HDFS component , and parquet file gets created properly when input table sql gives data. However, when input table sql gives…
omkar
  • 1
0
votes
2 answers

Integration of Oracle DB or APEX with Abinitio

How to integrate Oracle DB/APEX with abinitio. Scenario : I have a Abinitio code which generates the monthly report. So being database developer i wants to run same code which is in abinitio and generates monthly report. So i am looking for any…
Prajakta Pardeshi
  • 11
  • 1
0
votes
2 answers

Declare Dates Vector in Abinitio

I know how to declare a vector of integer elements in the package editor. let int[] int_vec; But how can I declare a vector with date elements and it's in the 'YYYYMMDD' format. I tried this and it has syntax error. let date[] date_vec; I have…
Dozel
  • 149
  • 1
  • 10
1 2
3
4 5 6 7