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
1
vote
2 answers

Talend: Combining data from two conditional subjobs into single file

I am trying to replicate a abinitio job in talend. I have two starting point(conditional) in the job, and I am using tjava IF Trigger to make any one of the sub-job execute. Now since, either one of the sub-job would execute, I am willing to put…
NishantM
  • 141
  • 12
1
vote
1 answer

Abinitio graph extract Information

I have an Abinitio graph with multiple subgraphs in it. I need to extract following information about the graphs: List of i/p files, o/p files, i/o tables, lookup files, run program, etc. How can I automate this process of extraction of all graphs…
Gaurav Chavan
  • 39
  • 2
  • 7
1
vote
2 answers

Running an Ab initio graph through UNIX

I'm trying to run an Ab initio graph through UNIX by making use of the air sandbox command. I'm connecting to a remote server through putty. I keep getting an 'Air not found' error. What environment changes do I need to make before I can get the…
karansabhani
  • 137
  • 4
  • 14
1
vote
1 answer

Run ab-initio graph through java?

I'm trying to create a java based automated testing framework where users can run ab-initio graphs and compare results. Is it possible to execute an ab-initio graph through java? There's an AIR SANDBOX command in unix which I believe can be used to…
karansabhani
  • 137
  • 4
  • 14
1
vote
1 answer

AbInitio - Include Additional Headers in Call SOAP HTTP Service UTF8

I am trying to use the Call SOAP HTTP Service UTF8 component to call the webservice in AbInitio graph. But an additional header, X-Authorization is mandatory and needs to be passed. From the WSDL, I have imported, I can see the SOAP env and body…
JonSnow_of_AbInitio
  • 11
  • 2
1
vote
4 answers

To fetch based on filter by expression component in ETL

I have filter condition based on date. where it needs fetch records between given dates. in filter by expression I gave as below the field is date datetype and format is YYYYMMDD fieldname >= '20020502' and fieldname <= '20050430' but records are…
Jay
  • 71
  • 2
  • 10
1
vote
1 answer

Create Web Service in Ab initio

I have a requirement to create a web service in AB INITIO. Using Java API I need to call that AB INITIO web service. Pls advice, how can I create a sample web service in ABI INITIO. I would like to know whether creating a Web Service in AB INITIO is…
user385394
  • 11
  • 1
  • 3
1
vote
1 answer

Is it possible to export Ab Initio graph as image?

Am doing migration project, migration of Ab Initio graph to java. Is it possible to export Ab Initio graph as image so that its helpful to refer specially when Ab initio IDE is not available. So far am doing print screen but as graphs go bigger and…
Jitendra Vispute
  • 709
  • 8
  • 18
1
vote
1 answer

Ab Initio - Formatting a number in Left alignment

I have a requirement in Ab Initio to format a number in left alignment. I shouldn't be using String conversion (as Strings are left aligned by default), as it might cause compatibility problems in the other end. For example, if my Field has 7 bytes…
Veera
  • 32,532
  • 36
  • 98
  • 137
1
vote
1 answer

string mismatch error while joining two files

I am joining two files. One file is a extraction from table(in0 port) having record format like this utf8 string("\x01", maximum_length=3). And another file is a normal text file(in1 port) having record format like this ascii string(3). While…
Nitish
  • 11
  • 5
1
vote
4 answers

Ab initio component to stop the graph if duplicate rows/records found

Hi I have an Ab initio graph that after some data manipulation it loads them into a table. I am looking for some sort of validation component to end the process (before loading the data into the table) if it found duplicate rows. The duplicate rows…
Achilles
  • 711
  • 2
  • 13
  • 35
1
vote
2 answers

Does Ab Initio support Oracle Merge statement?

Am attempting to design an Ab Initio load process without any Ab Initio training or documentation. Yeah I know. A design decision is: for the incoming data files there will be inserts and updates. Should I have the feed provider split them into to…
Alan Jurgensen
  • 813
  • 11
  • 20
1
vote
2 answers

How to find old recovery files on Abinitio production boxes?

Can any one throw some light on the process of finding old recovery files in abinitio production boxes
Srihari
  • 2,509
  • 5
  • 30
  • 34
0
votes
0 answers

Spark/scala code to load json files failing randomly with error java.nio.charset.MalformedInputException

Below spark code to load json file is failing sometimes. Json files always have utf-8 encoding only. Our spark jar is invoked thru AbInitio Graph which is scheduled to run in TWS. Backend execution runs fine but running thru TWS gives this error…
Anand
  • 39
  • 7
0
votes
0 answers

How to write regular expressions in the Rules Grid in Abinitio

I have a regular expression which is working perfectly fine in the Sheet view in Abinitio ExpressIT but I am trying to do the same in the Rules Grid / Grid view But I am not sure which function can I use in the Rules Grid. Tried with re_get_match…
JKC
  • 2,498
  • 6
  • 30
  • 56
1
2
3 4 5 6 7