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
4
votes
1 answer

"Metadata driven" means what? I keep hearing this phrase in ETL context but could never figure it out

Appologies if I am asking a inappropraite question but I have been hearing this phrase "Metadata driven" for years but could not ever understand. Metadata as per my understanding is Data (iformation) about data! I understand this more or less!! But…
Pritesh
  • 1,938
  • 7
  • 32
  • 46
3
votes
1 answer

Abinitio & Recommended Usage Scenarios for Data Import / Export Processes

I'm curious to find out if anyone has some real world experience using Abinitio for data imports, manipulation, exports and if you highly recommend it. I'm looking to solve a scalability issue with this process and would like some feedback if it…
Dean Poulin
  • 1,168
  • 1
  • 9
  • 22
2
votes
1 answer

Killing FitNesse from within a fixture

I'm using FitNesse to do some testing with Fixtures written in C#. One of my fixtures kicks off some testing suites to run in Ab Initio in a Unix environment. I would like to be able to kill the whole test suite if one of the tests within it fail.…
intA
  • 2,513
  • 12
  • 41
  • 66
2
votes
1 answer

How to change a string delimiter in Ab Initio?

In Ab Initio graph I have an input file which has pipe-delimited values in rows. I use similar DML file to parse it: record decimal("|",0, maximum_length=19, sign_reserved) v1 = NULL(""); utf8 string("|", maximum_length=10) v2 = ""; utf8…
Denikin
  • 21
  • 1
  • 8
2
votes
1 answer

How are user defined properties extracted from an ERWIN data model, and stored in the Ab Initio EME?

I believe this can be done using the erwin 2 eme connector graph. What are the steps involved in setting this up? How are user defined properties stored in the EME?
user17880
  • 43
  • 1
  • 7
1
vote
1 answer

How to update dml for all components in a graph

Is there a way to update the dml of all components of a graph ? I have large graphs having more than 100 components. We have to add utf8 in the beginning of all dml as the charset of the database on which they are running is utf8. As of now, I am…
Sonali Singh
  • 21
  • 3
1
vote
3 answers

How to achieve below using Abinitio component?

My Input is something like below: fieldname Anusha My requirement to get the output as follows: fieldname A An Anu Anus Anush Anusha
Anusha Mullapudi
  • 19
  • 1
  • 2
1
vote
0 answers

Ab initio scan component

Suppose I have the following records: code sequence_no group_no 4 1 1 2 2 1 3 3 1 4 4 1 1 1 2 3 1 3 4 2 …
Dozel
  • 149
  • 1
  • 10
1
vote
1 answer

Ab-Initio dml-to-hive

I am using AbInitio and attempting to have my results from my query in my Input Table populated into hdfs. I am wanting the format in parquet. I tried using the dml to hive text but the following is my results and I am not sure what this means. $…
ccr6924
  • 11
  • 1
  • 2
1
vote
2 answers

Removing white spaces between numbers using regex in abinitio if length is 9 by excluding spaces

For example , If My Input is : some text here 345 646 356 some text 235 5343 Output should be : some text here 345646356 some text 235 5343 In this case, it needs to remove spaces between numbers if length is 9. otherwise spaces should be as it is…
vijaya
  • 11
  • 2
1
vote
2 answers

RHEL - Environment variable

I have an environment file named .env337_dev. I need to run this file to set the environment before running another command. How to run this file? Inside the file, it contains several variables like this export…
Newbee2
  • 179
  • 1
  • 1
  • 6
1
vote
3 answers

Ab initio to read comma delimited values

What should be my DML for input file which has data like 1,2,34,43,66 The problem which i am facing when i put the below DML record decimal(",") val; end; is that the last number is not getting read properly. Is there any way to read this by only…
Yash Sinha
  • 11
  • 1
  • 2
1
vote
0 answers

How to connect to Google BigQuery from abinito

I would like to read the data connecting to google big query from AbInitio GDE to copy the data. Any help on this is greatly appreciated.
ITUser2019
  • 11
  • 2
1
vote
3 answers

Ab initio rollback

I have an Ab-Initio plan consisting of more than one graphs in it. If the plan failed in one particular graph during its 6th phase, then how can the plan be restarted from the particular graph and that too from the beginning. Note: Not for the last…
ruby
  • 11
  • 2
1
vote
0 answers

How to implement conditional dml and sub records concept of Ab-Initio in Talend

I am replicating an Ab-Initio graph to a Talend job , but the thing is that I am new to Talend, so I am facing an issue with it. In Ab-initio we have a concept of sub records and conditional dml. I want to implement these things in Talend. So my…
GadaaDhaariGeek
  • 971
  • 1
  • 14
  • 33
1
2 3 4 5 6 7