Suppose we have two input files A and B both having different columns & data, for example A having 1 2 3 4 columns and B having W X Y Z, How to get output as 1 2 columns from A and W X Y from B

Khaja

• Apr 11th, 2018

Reformat is used to drop the fields. By using reformat drop the fields from two files and get the output as required give input to fuse.

gouse

• May 27th, 2016

We have to specify 1,2 columns from A w,x,y from b in fuse component o,p dml. then combine two files
By using fuse components. By using we cont achieve this op

Answer Question  Select Best Answer

Suppose I have a project having many xfrs, I cannot check manually to understand the complexity of a xfr or graph, How can I check it, any command?
Can we understand its complexity just by checking dependency of a graph or XFR?

Sandeep

• Mar 25th, 2018

Air project analyze-dependencies relative_path -complexity
air project analyze-dependencies relative_path -complexity-details
air sandbox validate-graph path -complexity
air sandbox validate-graph path -complexity-details

Answer Question  Select Best Answer

What is Interpretation in Abinitio? What are types of interpretations available and its uses? Where do we use each interpretation?

Sandeep

• Mar 25th, 2018

Constant,$substitution,${}substitution,PDL

KV

• Mar 7th, 2018

Types of interpretation- PDL, Shell, Substitution

Answer Question  Select Best Answer

What is max core value? wat is the use of max core?

Ganesh S

• Jan 24th, 2018

Graph will not fail if there is enough space in the disk..max_core is an component in memory where this will be utilized when it is allocated else disk memory will be utilized.

Jyoti

• Dec 29th, 2017

If we change max-core value zero, does component work or fail?
Please provide me explanation.

Answer Question  Select Best Answer

Ketan Khot

• Jan 12th, 2018

Go with the profile transform. Run your graph with profile transform option to track which statement or function is taking more time so you can updated the code accordingly. Go with graph tracking o...

Mukund

• Dec 28th, 2017

For point no. 2) lookup_local (Which is now replaced with lookup_first_local) can be used efficiently only when data is available in same partition of parent lookup file else it will give NULL results

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

How we can make N number (say 50) copies of a file in GDE without using replicate?

irfan1patel1

 Profile Answers by irfan1patel1 Questions by irfan1patel1

• Nov 21st, 2017

This is a strange requirement as in ideal world no-body wants duplicated data in their server. To answer the question I can suggest below two solutions : 1) In the end of the graph call a Run_progra...

Shabnam

• Jan 18th, 2017

We can use Normalise component with the length value=50.

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

Sudharshan

• Nov 14th, 2017

1. Use normalize or meta pivot to convert the rows into columns or columns into rows. 2. If you use normalize, set index =2 and then write the below code in normalize function out :: length(in) = b...

sonalika

• Sep 21st, 2017

step 1. use normalize - lenght=2 and set indicator c1 for 1st records and c2 for 2nd records. op would be - c1 1 colum1 column2 c2 A c1 2 c2 B c1 3 c2 C ste...

Answer Question  Select Best Answer

vijay

• Nov 14th, 2017

Air sandbox run is the command to run abinitio graphs in Unix.

Mounika

• Jul 22nd, 2016

Go to run directory path:
/.../sandbox/run > air sandbox run /(graph_path)/sandbox_name/graphname.mp

if any graph level parameter is to be overridden then..
go to run directory path:
/.../sandbox/run > air sandbox run /(graph_path)/sandbox_name/graphname.mp -parameter_name parameter_value

Answer Question  Select Best Answer

In which scenario, .rec files will not get created even if graph fails? How to use in Abinitio graph?

vijay

• Nov 14th, 2017

.rec files will be created only if you have checkpoints enabled in your graph.

Prakash Poongavanam

• Oct 14th, 2016

.rec file will not be created if you not enabled checkpoints in your graph. So even if it get failed the graph will start from the beginning as there is no .rec file in the $AI_RUN directory.

Answer Question  Select Best Answer

What is the difference between global and local parameters

Srikanth

• Nov 10th, 2017

Global variables we can use all over the package where as local variable is for procedure or functions only

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

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

What is PDL? Explain with an example?

Anil

• Sep 25th, 2017

PDL is used for dynamic metadata injecting like DML into existing DML.

jaleel syed

• Jan 23rd, 2017

When you want the graph to behave dynamically, use PDL. ex: to add a dynamic field to the pre-defined DML

Answer Question  Select Best Answer

Sandeep

• Sep 11th, 2017

Local and Input parameter
local are handled by users while input parameters are handled by developers.

saigoud

• May 16th, 2017

1) Local parameter and 2) Global parameter

Answer Question  Select Best Answer

If a DML is changed, how to find out the impacted objects using a command?

sandeep

• Sep 11th, 2017

"air object uses" has been replaced by "air object referencing-files"

Jagnyadatta Sena

• Jul 26th, 2017

We can use all below:
air uses
air object uses .

Note: If dependency analysis is not there for the checked-in object, these commands will not show any output

Answer Question  Select Best Answer

How to delete a record from a multifile?

Sandeep

• Sep 10th, 2017

Linux command:
vi `m_expand -native file_name`
it will expand the control file and allow us to edit in all partition.

SP

• Jun 5th, 2017

a. Build a duplicate graph with the same logic that processes the file b. Select Never Abort for that component where a failure may occur. c. Arrange Reject port for that component and run the grap...

Answer Question  Select Best Answer

SP

• Aug 31st, 2017

Lock is a version control mechanism in Abinitio. It is used to maintain data/code synchronization between EME and multiple sandboxes. It avoids to modifying the code simultaneously be different users at the same time.

sixto.dsilva

 Profile Answers by sixto.dsilva Questions by sixto.dsilva

• Apr 18th, 2008

Lock mechanism is used by EME datastore to avoid confusion in the version control of a graph basically locking give a exclusive permission to modify and save it for a particular users and prevents other from making changes to the same file.

Answer Question  Select Best Answer

How to find corrupted record in multifile?

Monika Rani

• Aug 25th, 2017

M_dump dml file -show-partial -partition n

by giving value of n, check for each partition

Preetilagna Dash

• Aug 22nd, 2017

M_dump dml fileurl -show-partial

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

jyotiprasad

 Profile Answers by jyotiprasad Questions by jyotiprasad

• Aug 17th, 2017

String_join(Accumulation (in.id),"");
Try this in rollup
Hopefully it works

Jyotiprasad

• Aug 12th, 2017

Use meta pivot or nomalize component

Answer Question  Select Best Answer