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

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

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

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

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

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

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

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

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

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

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

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

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

I have 100 records in input file if I run graph first time first 20 records will go to output, in next run 21 to 40 records will go to output, like this in 5th run 81 to 100 records will to output. Please let me know how can I achieve this?

Thanks in advance

siva

• Apr 17th, 2018

Use the Partition by round robin component and set the block size 20

Natrayan

• May 16th, 2017

We can use the Partition by range component to segregate the record based on record number

Answer Question  Select Best Answer

I have a record like below:
avi,mahi,virat,mahi,avi,virat,mahi,virat,avi
Output should be:
avi1
mahi1
virat1
mahi2
avi2
virat3
mahi3
virat4
avi3
Please suggest how can I achieve this.

neha.nagare

 Profile Answers by neha.nagare Questions by neha.nagare

• Apr 26th, 2018

Flow I/p ->normalize ->scan->o/p We can achieve this by using normalize and scan component ,make vector by using string_split function and assign size of the vector to the length function of the no...

Sandeep

• Mar 25th, 2018

Use scan component using check sort attribute as false(maintain order-false)
then use name as key and for sequence number use count(in.name)

Answer Question  Select Best Answer

How to use rollup Component as Scan Component? On what condition Rollup component can be used as SCAN?

Jatin

• Apr 30th, 2018

Rollup will produce same number of columns as scan only in case when all the columns are selected as rollup key

Speedy

• Sep 22nd, 2017

As per my understanding, we cannot use rollup component as a scan component. The reason for this is Scan gets the cumulative data and can process the same number of output records as the number of inp...

Answer Question  Select Best Answer

jatin

• Apr 30th, 2018

1. In memory components where input not need not be sorted is selected like Rollup,join,scan,
2. Sort component

sonalika

• Sep 21st, 2017

Sort breaks pipeline parallelism

Answer Question  Select Best Answer

What is the disadvantage of using multi-file if data volume is not much?

Jatin

• Apr 30th, 2018

1. When Graph starts there is time taken for start and shut down, so if data in multifile is not much use serial processing as over all time taken will not have any significant difference. 2. If mult...

Vinit

• Sep 26th, 2017

1. In multi files, there can be skew spillage due to imbalance in amount of CPU time
2. If data is not evenly partition, some of the partition can contain zero records and which will consume memory

Answer Question  Select Best Answer

How can we fetch next record data for a particular field in ab initio?
i/p
id sal
101 500
102 800
103 900
105 200
o/p
id sal Pre_sal
101 500 0
102 800 500
103 900 800
105 200 900

Sai

• May 14th, 2018

use scan component we have to achieve this scenario and the parameter key is "NULL({})"and find the below explanation.Here i am taking the 2 temporary variables as a,b. type temporary_type = record ...

neha.nagare

 Profile Answers by neha.nagare Questions by neha.nagare

• Apr 26th, 2018

We can achieve this by using reformat component by maintaining current and previous value of the column sal and by updating variable prev_sal with previous record value of column sal. Please find...

Answer Question  Select Best Answer