jatin chawla

• Feb 6th, 2013

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.

shashi_dhar

• Feb 19th, 2007

The largest input is nothing but a driving port

Answer Question  Select Best Answer

If I have 2 files containing field file1(A,B,C) and file2(A,B,D), if we partition both the files on key A using partition by key and pass the output to join component, if the join key is (A,B) will it join or not and WHY?

Abhishek

• Feb 5th, 2013

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...

vss34

 Profile Answers by vss34 Questions by vss34

• Jul 16th, 2009

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...

Answer Question  Select Best Answer

How to write the script in Abinitio by using unix?

Alok Sahoo

• Nov 15th, 2012

You can create a script in UNIX in the general way like you are writing a shell script.

Answer Question  Select Best Answer

How can you set the parameters to call the graphs?

shan88

 Profile Answers by shan88 Questions by shan88

• Oct 17th, 2012

Edit > parameters or F11

Answer Question  Select Best Answer

shan

• Oct 11th, 2012

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..

girish.v

 Profile Answers by girish.v Questions by girish.v

• Dec 19th, 2010

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...

Answer Question  Select Best Answer

shan

• Oct 11th, 2012

M_dump is used to view data as in graphs

m_dump [-dml] [-file]

Nv

• Feb 3rd, 2012

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.

Answer Question  Select Best Answer

What is phasing & checkpointing? What is the use ?

shan

• Oct 11th, 2012

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.

prem.k

• Sep 6th, 2011

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...

Answer Question  Select Best Answer

shan

• Oct 11th, 2012

Temp file

PN Reddy

• Feb 7th, 2012

.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.

Answer Question  Select Best Answer

shan

• Oct 11th, 2012

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

Ashutosh Prasad

• Sep 8th, 2012

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..

Answer Question  Select Best Answer

shan

• Oct 11th, 2012

Sandbox Level Parameters

Sachin

• Apr 26th, 2012

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

Answer Question  Select Best Answer

my requirement

header contains - business date
details contains - reccords
trailler contains - total no of records in detail.
1) header , detail , trailer separation with indicator filed ( conditional dml with indicator field )
2)Comparing header with business date , if not match fail. ( using lookup with date function)
3)comparing the record count of...

raju

• Oct 9th, 2012

Input dataset---->dedup sort------> output file

In dedup sort component next_in_sequence > 1 then keep parameter make it as last. output port getting the trailer record, dedup port getting the detail records (if header, detail and trailer are in sequence)

Rushieksh Deshapnde

• Aug 30th, 2011

In Reformat have output index separate header,trailer and data based on it in transform 0 write xfr for matching business date using lookup expression for that use

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 is the difference between m_mkfs and m_touch.
Both create a MFS how do they differ ?
Also what is the syntax for creating MFS using m_touch

balu

• Oct 6th, 2012

M_mkfs: to create a multifie system
m_touch: to create a empty file system

RAM

• Aug 17th, 2012

M_mkfs will creates a multifile system
M_touch will creates empty multifile

Answer Question  Select Best Answer

arya

• Oct 5th, 2012

Ab Initio Graphical Development Environment
Version 3.1.1 Build ID 427346

Co-Operating System
Version 3.0.5.5

Allen

• Oct 1st, 2012

Ab Initio Graphical Development Environment
Version 3.0.5.3
Build ID 411497

Co>Operating System
Version 3.1.2.6

Answer Question  Select Best Answer

On which parameter based broadcasting partition distribute the records to the outputs?

priti

• Jun 5th, 2012

There is no parameter in broadcast. It simply combines all the records from input ports to a single flow, and copies it to each of its output flow partition

Answer Question  Select Best Answer

anil

• May 21st, 2012

Hi,In abinitio we can create mfs with this command press F8 write the m_mkfs pathnamefilename

vijay_kramarao

 Profile Answers by vijay_kramarao Questions by vijay_kramarao

• Oct 30th, 2006

Syntax: m_mkfs <name of the control partion> <URL of the first partion> <URL of the second partion> <URL of the third partion>....... Eg: m_mkfs controlpartion c:abin...

Answer Question  Select Best Answer

Hi,

I have 3 files each having 2 cols
e.g
File1
empid deptid
1 100
2 200
3 200
4 100
5 300

File2
empid salary
1 10
2 20
3 30
4 40

chandrasekhar

• May 10th, 2012

1.Perform inner join for both file1 & file2
2.perform sort on dept id then do Roll up
3.perform inner join for roll up o/p and file3
4.finally you will get required result

Answer Question  Select Best Answer

suren

• Apr 16th, 2012

We can achieve that through the rollup ...

annegrace1

 Profile Answers by annegrace1 Questions by annegrace1

• Apr 8th, 2009

Rollup will help to avoid the duplicate without using dedup component.It takes the first record and reject the rest

Answer Question  Select Best Answer

How do you find the size of MFS file?

Vinoth raj

• Mar 29th, 2012

Use m_ls -ltr file name you will have the record count and also size of it.

PN Reddy

• Feb 9th, 2012

Using m_expand you can know the count of partition on the file

Answer Question  Select Best Answer

How to remove Header and Trailer records from a file using abinitio components?

arnab ghosh

• Feb 22nd, 2012

Use Unix SED #--------------------------------------------------------------# # This line removes both the header and the trailer record #----------------------------------------------------------...

nagarjuna

• Jul 22nd, 2011

You cam redefine format, Filter by expression & Run program components.

Answer Question  Select Best Answer