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

If I am having two table- customer and transaction. I am having 100 rows and 10 columns and I want to perform the join with NULL key, then how much output records I will get?

nagesh

• Aug 17th, 2017

Cartesian product :100*10= 1000 records

Kiran

• May 8th, 2015

If you are passing null key to Join component , you will get Cartesian product (input1 records X input2 records).
Thanks in Advance.

Answer Question  Select Best Answer

I have fields like a10 b20 c123
If we give numeric value (any number) as key in sort component, what would be the expected result?

Do we get a sorted order? or Does the sort component spits an error?

jyotiprasad

 Profile Answers by jyotiprasad Questions by jyotiprasad

• Aug 17th, 2017

Sort the data based on ASCII value

Anil dara

• Aug 17th, 2017

In sort component for example i have 1-10 numbers i specified in the sorted key as 5 it throws an error called "error in key specifier {5},filed "5" not found in record.

Answer Question  Select Best Answer

If data is still loading into table what mode will you use to see the data?

notjustaprettygirl

• Jul 24th, 2017

API mode. The main difference between the two modes - API and utility is that API commits after predetermined number of transactions where as utility commits only after all transactions have been processed. Hence API is slower but recovery is faster and utility is faster but recovery is slow.

Answer Question  Select Best Answer

How to find a corrupted record in Multi file and how to correct the data if you know the correct value?

MJ

• Jul 4th, 2017

Considering scenario that record is not matching with metadata, thus it is bad, then you can find out it by using below method:-

m_dump

You will get record which is not matching with metadata & that will be faulty record

Vinit Singh Sheokand

• Jun 30th, 2017

This can be possible using m_dump with argument -show-partial

Answer Question  Select Best Answer