saikumar

• Jun 29th, 2022

Multistage componets means transform components rollup,reformat,and scan normalize

Anjali

• Nov 19th, 2021

Multistage transform is a transform that modifies in up to five-stage - input selection, temporary initialization, processing, finalization and output selection
multistage transform components are -
rollup
scan
scan with rollup
normalize
denormalize sorted

Answer Question  Select Best Answer

Mathi777

 Profile Answers by Mathi777 Questions by Mathi777

• Jul 3rd, 2008

When ever a graph fails it creates a .rec file in the working directory ,the directory may be where ur graph deployed script is stored .so remove that .rec file an dthen run the deployed script of the graph from unix,u may use m_rollback -d

sixto.dsilva

 Profile Answers by sixto.dsilva Questions by sixto.dsilva

• Jun 25th, 2008

You can run the graph by giving the following command in unix dtm run <recvory file name> -continue

Answer Question  Select Best Answer

How do we merge graphs in AbInitio?

abhi_fresh_as_dew

 Profile Answers by abhi_fresh_as_dew Questions by abhi_fresh_as_dew

• Dec 11th, 2008

Get on using .plan in Abinitio in which we can encapsulate different graphs.Abhisek Bfresh as dew!!

Sabitra S Panda

 Profile Answers by Sabitra S Panda Questions by Sabitra S Panda

• Dec 10th, 2008

Any graph in ab initio is a separate and independent entity in itself. First of all, there is no such concept of graph merging in ab initio, since it does not make any sense, and two graphs that are s...

Answer Question  Select Best Answer

Can we process 1 GB data(1 million records) by using Lookup? How

abhi_fresh_as_dew

 Profile Answers by abhi_fresh_as_dew Questions by abhi_fresh_as_dew

• Feb 3rd, 2010

Processing 1GB data with a small lookup file is good ... but to make the 1GB data as a lookup file is mistake.Use mfs lookups instead if its at most needed.

anujaja

 Profile Answers by anujaja Questions by anujaja

• Aug 25th, 2009

I will suggest you to use Join instead of Lookup for such voluminous data

Answer Question  Select Best Answer

How do change serial file into MFS? Explain

abmaahi

 Profile Answers by abmaahi Questions by abmaahi

• Mar 29th, 2010

Go to run command or press F8You will get the one text box in that type m_mkfs [path0] [path1]..This is for cration of multifile system after that create one file in that path by using m_touch [path0]...

njvijay

 Profile Answers by njvijay Questions by njvijay

• May 11th, 2008

1. Make sure you have multifile system in your ab-initio environment2. Then use partition component to distribute your records to MF

Answer Question  Select Best Answer

In production also do they will give same password which was given in .DBC?

sixto.dsilva

 Profile Answers by sixto.dsilva Questions by sixto.dsilva

• Jul 3rd, 2008

Best way is using the environment variable  to set the values in dbc file. By this you can have the flexibility to change any variable value's by changing the evironment variable.

njvijay

 Profile Answers by njvijay Questions by njvijay

• May 11th, 2008

Good way doing this is, parameterize .dbc file. Parameter will have different values for different environment.

Answer Question  Select Best Answer

There is one MF while loading data i deleted one partition in a MF? Can it show error/it will process data?

sixto.dsilva

 Profile Answers by sixto.dsilva Questions by sixto.dsilva

• Jul 25th, 2009

yes the above point is also valid , if file does not exist , the ab initio will throw an error. If it is truncated ,you will loose the data but abinitio will not throw an error.

njvijay

 Profile Answers by njvijay Questions by njvijay

• May 11th, 2008

Did you delete data in partition or deleted partition itself?If data is deleted (or truncated) in a partition, ab-initio does not throw the error.If a partition itself is deleted, ab-initio is going to throw the error.

Answer Question  Select Best Answer

sixto.dsilva

 Profile Answers by sixto.dsilva Questions by sixto.dsilva

• Jun 22nd, 2009

I think i misunderstood the question ,there are 3 type of parallelisms in Ab Initio , details of 3 types are expalined correctly above with difference.

ravula sudheer

 Profile Answers by ravula sudheer Questions by ravula sudheer

• Oct 18th, 2008

ab initio supports parallilesm..parallilesm 3 types 1.component parallilasem: graph running the data sumaltenously on seperate data uses. every component graph creates one component process ..this is ...

Answer Question  Select Best Answer

If a graph fails in between loading 1 millon records to a target table what is the alternative solution? I.e Will you run the grarh again? (The record count is very huge)

Raja

• Feb 10th, 2015

Its better to use check points and commit number in table to commit set of records before failing the graph

shan

• Oct 11th, 2012

Use checkpoints and partitions

Answer Question  Select Best Answer

I have already created graph,and need to modify it so that output file gets page breaks. Any idea how can we implement page breaks in abinitio.

Anu

• Jan 10th, 2020

Sed G filename

swarna

• Apr 10th, 2014

I think they mean inserting new line character in unix or
meaning carriage return in windows environment.

Answer Question  Select Best Answer

Hi Guys,

I have a requirement :

We need to design a graph for transition of some files. The details like filename, parameter_id (unique) we need to get from a table in DB and these should be included in the graph pset one at a time. That means for every unique parameter_id graph should run once.

Like we can have the parameter_id as the Job_name for the graph.

Satish

• Oct 8th, 2012

I am really not sure why you will have to create a dynamic PSet. That parameter file is for the static values but not the dynamic values. If you have some value witch is stored in the system and if yo...

Siva

• Jul 11th, 2012

You can use the air commands to create PSET for graph and add parameters to PSET. These commands can be executed in the wrapper scripts inside the while loop.

example/syntax:

air sandbox pset graph1.pset -protoype $PROJECT_DIR/mp/mygraph.mp

air sandbox parameter -path

Answer Question  Select Best Answer

What will be output for Inner join having no key when I/P in two respective Input Ports are:-
Input1 = 1,1 (one record with two fields)
Input2 = 1,1,1 (one record with three fields)?

vijayv

 Profile Answers by vijayv Questions by vijayv

• Feb 3rd, 2012

Yes, this is wonderful scenario.
in0:1,1
in1:1,1,2
when we are using inner join wil get 4 records
(1,1)(1,1)(1,1)(1,1).
when we are using cartesian join (with out key) wil get 6 records.
i.e. 2 X 3 records....(1,1)(1,1)(1,2)(1,1)(1,1)(1,2) records.
Thank you

P N Reddy

• Jan 12th, 2012

Yes you will get only one record when you have not given any key in join that will give you the cartisean product. since you have the inputs as in0-1record and ina-1record 1 cross 1 is 1. the output ...

Answer Question  Select Best Answer

Hi,

How can I configure email notification for any graph failure with error and compnent details which caused the failure in AB Initio

NicoRobin

• Jul 8th, 2020

You can use $mpjret variable in the end script which returns the status of the graph as below:-
if [$mpjret -eq 0]
then echo "successful execution"
else
mailx -s [graph name] failed mail-id

Rahul Rasal

• Jan 17th, 2018

By using RUN component you can write script with mail utility.
Thanks ...!

Answer Question  Select Best Answer

I have a scenario:
Input file
Col1 col2
1 A
2 B
3 C
4 D

and desired output should be like below:
col1 1 2 3 4
col2 A B C D

Could you please help

Kanimozhi

• Nov 18th, 2021

Col1 col2
A 1
B 2
C 3

ravichcv85

 Profile Answers by ravichcv85 Questions by ravichcv85

• Dec 23rd, 2015

By Using "meta pivot component" - we can change the input data into
col1 1
col2 A
col1 2
col2 B
col1 3
col2 C

In order to get the desired output -

col1 1 2 3 4
col2 A B C D

we need feed the output of "META PIVOT" component to De-normalize component.

Answer Question  Select Best Answer

How to generate sequence number in a multifile using next_in_sequence().

Sachin

• Feb 3rd, 2016

Next_in_sequence()*(this_partition()+1)

srinivasareddy

• Jul 21st, 2015

hi I think this will be help you if the mfs is 4-way if (this_partition() == 0)((next_in_sequence()-1))+this_partition()+1 else if (this_partition() == 1) ((next_in_sequence()-1))+this_partition(...

Answer Question  Select Best Answer

How to Split a 10 GB file into 10 files of 1 GB in Ab initio?

Mahesh

• May 26th, 2021

Use write multiple files component or create m_mkfs with 10 partition layout. Write data into that file with broadcast component, but might get 10 files in mkfs

Arun Ramaswamy

• Dec 9th, 2019

Why don't we use write multi files and take a approx rec space and do a split based on that.

Or keep as void of one and spilt when you write 1024*1024*1024*8.

Answer Question  Select Best Answer

What is Generic Graph? Explain with an example?

Aman

• Oct 30th, 2017

A generic graph is a graph which can be used multiple times for different kind of datasets.

jyotiprasad

 Profile Answers by jyotiprasad Questions by jyotiprasad

• Aug 13th, 2017

Generic graph is a graph where everything was parametised.
Benefits of this kind of graph is to build once and run multiple times with different kind of data.

Answer Question  Select Best Answer

If Input table is nullable and output table is not nullable then will the output table allow null values?

Aman

• Oct 30th, 2017

No.. Output table will not allow null value.

jyotiprasad

 Profile Answers by jyotiprasad Questions by jyotiprasad

• Aug 12th, 2017

No

Answer Question  Select Best Answer

I have a 4way mfs. I connected to rollup, i have mentioned key as null. How many records will come to output?

Mahesh

• May 26th, 2021

4 records, 1 per partition as rollup with be working in a component parallelism. So in the background there will be 4 processes each for a partition on which the component works.Hence 4.The question no where mentions there is a fan in happening anywhere.

Amaan Sajid Ansari

• Nov 14th, 2018

You have to understand how roll-up works, it makes group of records based on the key, If the key is null it considers all the record in a partition as one so it will throw 1 record per number of partition. In your case Its 4

Answer Question  Select Best Answer

JYOTI

• Dec 31st, 2017

Pipeline parallelism Data is pushed from component to component, via OS pipes, avoiding writing to disk. Component Parallelism Within the same flow, different sub-flows can execute at the same time...

sixtodsilva

• Sep 18th, 2007

Three kind of parallelisms1.Component Level Parallelism --> different components acting on different data at same time.2.Data Parallelism --> A graph that deals with data divided into segments a...

Answer Question  Select Best Answer