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

Ab initio m_dump command output to flat file with delimiter

I have a ebcdic file, I wanted to select only first 2 columns values in the output in the m_dump command Output of m_dump values are like below: [record id "100" type_code "20" frstname "abcd" lastname "efgh" new_line "\n"] or please help me to…
Sobha
  • 1
  • 1
  • 2
0
votes
2 answers

Difference between NULL and NULL("") in DML

What is the difference between writing a NULL value to the DML and the NULL with default value. Does writing NULL value is a bad practice? When to decide which method to be adapted.
Omniverse10
  • 134
  • 2
  • 15
0
votes
3 answers

Identify which unix port is bind to a process or not

I have a Abinitio process running on a Red hat server. This process is basically a webservice, which is bound to a port on this running unix server. The front end sends request to this UNIX PORT, which is in turn read by abinitio process and…
NishantM
  • 141
  • 12
0
votes
0 answers

Unix command not running as expected using JSch

So I have a unix command which executes an ab-initio graph: export AB_HOME=/opt/abinitio/installations/Saturn_Abinitio/ab_home;/opt/abinitio/installations/Saturn_Abinitio/ab_home/bin/air sandbox run…
karansabhani
  • 137
  • 4
  • 14
0
votes
0 answers

MAX-FILES param in WRITE HDFS component issue

I have a hadoop table which is partitioned on event_date and MAX_FILES param is set as 200. Now I am trying to load 180 days data. Technically it should work as it will open 180 files. But it's failing. If I assign a higher value e.g. 300, it is…
Sonalika
  • 1
  • 2
0
votes
1 answer

Abinitio- To connect same graph having 2 phases but to run in different database

Can you please help me to understand how to connect to belonging to different database How can we create have 2 dbc in same environment (Here users are different so think it would be easy to have dbc as its same server(IP)); what if the server are…
Rakesh
  • 1
0
votes
3 answers

Passing Existing Record For Update Again In Update Table Component In Abinitio

What happens if an already existing record is sent for an update query as it is to an update table component? Does it go unused? I have an abinitio output file which has records to be updated(not inserted). I need to collect only those records which…
Richa Garg
  • 37
  • 7
0
votes
1 answer

Unix MFS and Serial File

How do you differentiate a serial and mfs file. For e.g a user can create his own directory and put the file over there , so how do you differentiate the file before you use a command. Can anyone tell me what does 'i' and 'e' means in grep -i or…
Raj Sharma
  • 21
  • 2
  • 8
0
votes
1 answer

Calling Ab-initio web service from java

I have created a web service in Ab-initio, I want to call that web service from java, I have read a lot information from help file. It gives me some information about plugin, but they have not mentioned it specifically that how to call service…
Aniket Amrutkar
  • 23
  • 6
0
votes
3 answers

charset conversion from string to window-1252 in abinitio

I've below input string from source and I am using mssql database to Load the data into a table, but I'm getting below error from tables: Error from Component 'LOADP51file.Output_Table_1__table_.load', Partition 0 [U103,DB00156,DB16000,DB00250]…
Ashishgupta
  • 1
  • 1
  • 2
0
votes
3 answers

Difference between serial file and multi file in AB Initio

What are the differences between a serial file and a Multi file in Ab Initio?
Polukanti Gouthamkrishna
  • 1
  • 1
  • 3
0
votes
1 answer

In AbInitio, will join take the same time to process matched records as that of unmatched one?

In AbInitio ETL tool, If there is a inner join component and million records are matched on some keys, there is some simple transformation logic in the join itself and rejected records are collected to process further. Will join take same time to…
Saket Mankar
  • 25
  • 5
0
votes
1 answer

How to handle zero length vector in split component

I am working on creating a generic application to handle any vectored data. The application is working fine in Normal scenario... But the split component I am using is failing to handle a zero length vector. Kindly share your views n…
Tushar Saxena
  • 1
  • 1
  • 4
0
votes
3 answers

How to check whether a file is serial or partitioned using abinitio functions only

I need to resolve a parameter value depending upon whether I have a serial or multifile. Below is the scenario... I have created a generic graph where I have a reformat component just after the input file component... At run time! I need to check…
Tushar Saxena
  • 1
  • 1
  • 4
0
votes
2 answers

ab initio join component to determine the mismatch join key

I have two file of the same format and columns and i am comparing them by passing them in a joiner and setting join key to all the fields. file a: ID DESC CODE COMMENT VALUE 1 AFAF 34 GDG 34 2 DGF 45 DGDF …
Ankit Srivastava
  • 185
  • 3
  • 13
1 2 3 4
5
6 7