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

Find list of schema.tables from abinitio graphs

can you please help me to get the answer of below question: I have more than 50 ab initio graphs, in which Db2 tables have been used to fetch data, but the schema.table names are all parameterised. How to find the list of all tables with schema…
pushpendu dhara
  • 97
  • 7
0
votes
1 answer

Get files from Ab-initio server to SFTP server

I need the shell script to pull the .dat file from source server to SFTP server. Every time the job runs, shell script has to verify if the table already exists in sftp server and get all the files corresponding to that table with date greater…
sravs
  • 43
  • 3
0
votes
0 answers

Ab-initio Graph to Java conversion

I want to convert Ab-initio graph to Java. Can someone please suggest if he or she has worked on this earlier and what should be the approach for this.
vikas m
  • 23
  • 4
0
votes
1 answer

Related to abinitio graph and pset

can you please help me to get the answer of below question: I have a generic graph which has many .psets ,if my graph has failed then is there any way to know which pset has failed.
sasmita s
  • 1
  • 1
0
votes
0 answers

Why does this error occur in abinitio while loading to Teradata? "Input port closed while active (unread data remains)"

I am loading in Ab Initio from input file to Teradata table via PT_api_utility using Output Table component. It has been running fine since long but today it threw error: Error from Component 'TARGET_TABLE__table_.tload', Partition 0 [B1] Internal…
Richa Garg
  • 37
  • 7
0
votes
1 answer

I have 4 way parallel i/p file, 6-way parallel i/p files.I want to write the data into 8-way multifile.How can you do this?

I have 4 way parallel i/p file, 6-way parallel i/p files.I want to write the data into 8-way multifile.How can you do this?
user9703636
0
votes
1 answer

.rec file usage incase if we want to run graph form specific phase

In abinitio, job has failed in specific phase for example phase 4, and we fixed the issue and rollback the .rec file, if we want to run the graph from phase 4 only, how to do it?
user9703636
0
votes
1 answer

How to trigger email for every check-out in EME - Ab Initio

I would like to create a new notification email with each checkout in EME (Enterprise Meta Environment). I have been searching the web for a valid lead but I didn't come across any blogs or article.
mightyteja
  • 825
  • 1
  • 14
  • 38
0
votes
3 answers

Abinitio : Writing data to a target table

I am new to Abinitio and I need help for the following. Table 1 has columns : Col1 Col2 Col3 Table 2 has columns : col 4 col5 I am using join component and also reformat component and got the output as col2,col3,col4,col5. And I am writing this…
ITUser2019
  • 11
  • 2
0
votes
2 answers

How to map data from other languages to java

We have to store data from some flat files that is created using IBM's Ab-Initio product. They have their own datatypes that I need to map to java data-types while I process that data in java. Does anyone know what would a good technique to do so ?…
user656189
  • 139
  • 8
  • 17
0
votes
0 answers

Issue with Data Load and Index Rebuild in SQL Server 2016

Data load for one of the table in SQL Server is taking around 22-24 hrs and index rebuild is taking 4-6 hrs. Below are some additional details about the size and data load process. Table Size: 800 GB Total No.Of Indexes: 11 No.Of Partitions on the…
user1941025
  • 541
  • 6
  • 21
0
votes
1 answer

Ab Initio graph : partioning by key behavior with Replicate

I am asking myself a question concerning Let's suppose I have a flow F which is replicated X times. All the replicated flows are then Join on the same key but with different datasets each time. I want the joins to be run in a parallel layout. For…
LostReality
  • 657
  • 2
  • 8
  • 33
0
votes
1 answer

Comparison of Ab Initio and Data Stage

I am gathering comparisons of different ETL tools(Informatica, DataStage, Ab Initio) with respect to their usability and performance, I have worked on informatica and Ab Initio and with the web help I am able to find the key essential factors and…
KeenLearner
  • 685
  • 1
  • 8
  • 25
0
votes
1 answer

bad int8 external representation"VM000141210"

While running an ab-initio PSET I'm getting the error like: "bad int8 external representation"VM000141210"". What the pset does is take data from different source tables and loads into target table with transformations. Can anyone help me with this?
Chirag Majumdar
  • 1
0
votes
1 answer

How to transform fields in abinitio so as to have common schema in output file?

I have 6 files in which 2 files have 53 fields and rest have 49 fields. I want an output having a common schema of 53 fields THROUGH AB INITIO such that when I process files having 43 fields it comes as blank in the output schema by itself. How can…
Jinson Fernandez
  • 1
  • 2
1 2 3
4
5 6 7