Abinitio Interview Questions

Co -op : 3.1.5
GDE : 3.1.5
For any concern please check in online discussion browser.

3.1.4

Case:1 :If we can take null key in dedup sort also then output depend on keep parameter. keep: first: 1st record last: last record unique: 0 records Case 2: If we can take any ke...

Actually the thing is if u use sort component with {} key it will take alll values as key and pass the records as it is..and dedup will do pass the same if there is no duplicates

Usually when we use sort within groups we can sort the data by universally in the sense we can make sure pure sort by using defined keys....but if we use only sort we cant decide data dynamically and...

Sort with in group sort the data based on major & miner key in single time.

Sort component sort the data on a single key at a time.If we have sort with some other key again we have to use the sort component again.It take some extra time. That sort with in group using best way.

Hi All,

I appreciate I am a late entry for this question. I think tools like Jenkins can be used for Ab Initio automation test harness. Please correct if I am wrong.

Yes thats correct. There is no automation testing available for Abinitio.
Manually U need to test the abinitio graphs using Validate category of components.

Thanks

Use Full outer join. Match the key using name and you can pull the matching and unmatched records

Skew of a partition is the amount by which its size deviates from the average partition size

statistically, skew represent distribution of data.. when all partitions share equal amount of data, it is the best use of portioning. This can be achieved by partition-by-roundrobbin or by using equ...

When using in-memory Join we choose one of the input as driving port which is not taken into memory rest all inputs are loaded into memory. Driving port should be the largest input taken. this can be set in the parameter.

The largest input is nothing but a driving port

Yes, this is going to work fine provided u do it as in-memory. Let me explain why, firstly whenever you are using the field A as a key, for the same data in the both the files, would definitely go int...

The partition key and join key do NOT have to be the exact same.  In order to join properly, you just have to make sure the records being compared are in the same partition.  So if the parti...

sed -n 50,75p file1 > file2

use LEADING RECORDS component
with condition
next_in_sequence()>=50 && next_in_sequence()<=75

If you are not tagged the older version object (102).. and still you want to checkout the older version, than create a tag for the older version (102) by using r-tag option and do a checkout.

Just unlock the graphs!

m_db < dbc name > -table < table name >

we can use gendml command to generate the dml file, pls, see the below syntax of command

m_db gendml ur_dbc_file -table -select sql statement > dml file name

hope this would help you :-) :-)

use checkpoints and partitions

We can commit intermediate results in the target table by creating a commit table in API mode. When we rerun the graph, it will skip over the previously commited records. Use m_db creat...

Forces error and writes the error note..

It will not stop the execution of graph,it will continue with the next records.
It will used especially to send to send the data to an error port when it does not meet the specified condition with error message given in this function. To abort the graph use force_abort function.

GdE runs on co op..whatever u run here on GDE runs with the help of co-op.

EME is for version control of GDE developed projects n plans.Its not that much necessary to have EME..i think..

GDE is Graphical Development Environment where user creates graphs(It is having GUI environment installed in wondows).Co>Op system is used for running the developed graphs either in Unix or in Wind...

m_dump is used to view data as in graphs

m_dump [-dml] [-file]

cat file.dml will work fine but it wont display the record format in a formatted way..You can think of m_dump as "view data in formatted " manner.

For efficient graph management to channelize the priority of the outputs we use phases

coming to check points,we use them to consume time that takes while running graphs..

By placing checkpoints graph resumes to run from its earliest checkpoint.

Phasing: Phasing in ab-initio means dividing the complex graphs into pieces. In order to improve the performance by reducing the resource utilization in different phases with in the same graph. Check...

maximum memory used by a component

Max core is nothing but allocating the memory in the component.

Rollup, sort etc are some of the components

temp file

.rec file contains the information which is required to rollback the graph when it fails

Generally it will have some meta char information with hld and nld extension.

On failure we use to rollback using m_rollback to rollback the job to last committed check point.

m-dump to display record format:m_dump [-dml] [-datafile]

m_dump is abinitio utility to view the content of a file[Serial/MFS] in a formatted way.

Syntax :

m_dump

There are other options such as :

-select
-no-print-data
-print-data
-start # -end #
-record
etc..

Sandbox Level Parameters

$AI parameters are sandbox level parameters like $AI_XFR, $AI_XML