i having 1000 records in in0 file.
i want first 250 records into out0 file,
next 250 (250 to 500)records into out1 file,
next 250(500 to 750) records into out2 file,
last 250(750 to 1000) records into out3 file using partition components?

Prajna

• Sep 3rd, 2013

It can be done by Partition-by-round-robin giving the block-size=250

shan

• Oct 11th, 2012

Partition by expression:next_by_sequence = 250

Answer Question  Select Best Answer

Vikas

• Jun 8th, 2013

I am not able to create .aix file for repository, by clicking the browse button its asking to select the file which is not present there.
now hot to create this file on windows. Also after creating this repository I wanted to create sandbox too.

Prasad

• Aug 9th, 2006

Hi, If you are trying to install the Ab -Initio on stand alone machine , then it is not necessary to create the repository , While installing It creates automatically for you under abinitio folder ( ...

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

PLMS

• Mar 29th, 2013

Step 1: File1 - left outer Join {Key- empid} with -File2 Step 2: The above output flow should be sort{PBKS-if multifile} based on key empid Step 3: The step 2s o/p flow to be left outer joi...

Malini

• Apr 3rd, 2012

Code
 

Answer Question  Select Best Answer

what is a Framework in abinitio all about? Can anybody explain me in detail about what an abinitio developer in general does in his job?

PLMS

• Mar 29th, 2013

The expected roles of abinitio developer has been below: i) Know how to work in Abinitio products GDE,EME,Co>Op & good exposure to unix scripting to create wrapper scripts & execute basic commands. ii...

Answer Question  Select Best Answer

Rajat Singh

• Feb 20th, 2013

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

vSudheer

 Profile Answers by vSudheer Questions by vSudheer

• Mar 3rd, 2012

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

Answer Question  Select Best Answer

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