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

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

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

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

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

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

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

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

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

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

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

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

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

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

Preeti

• Sep 25th, 2013

M_db gendml dbc_file [options] -select sql-select-statement

vamsi

• Nov 21st, 2012

M_db < dbc name > -table < table name >

Answer Question  Select Best Answer

sriks

• Dec 3rd, 2013

Co>op : 3.1.6
GDE : 3.1.6

shan88

 Profile Answers by shan88 Questions by shan88

• Oct 22nd, 2013

3.1.3

Answer Question  Select Best Answer

I have a master file with user personal details and around 50k users.
Each day a transaction file with about 100million records come in and we need to update transaction file with user details present in master file.

What is a good approach for this?

kalyanvadlamudi2kn

 Profile Answers by kalyanvadlamudi2kn Questions by kalyanvadlamudi2kn

• Jan 8th, 2014

1)I partition the data first 2)Remove unwanted fields if applicable 3)Followed by sorting on the matching key in first data if it can fit in memory without data spill as it small and other i wil...

sriram

• Dec 11th, 2013

Join with old master and new master file. you will get matched record those are not going to update. unused records are new records ,which are loaded into table.

Answer Question  Select Best Answer

kalyanvadlamudi2kn

 Profile Answers by kalyanvadlamudi2kn Questions by kalyanvadlamudi2kn

• Jan 9th, 2014

You have to use include in thXFR. We define all the common functions like strip blanks,format date etc., in a common xfr and can be used environment wide.

RAM

• Aug 17th, 2012

By the use of common xfr & by the use of include option

Answer Question  Select Best Answer

How do you perform Unit testing?

kalyanvadlamudi2kn

 Profile Answers by kalyanvadlamudi2kn Questions by kalyanvadlamudi2kn

• Jan 10th, 2014

Turn on the debugging mode and insert the breakpoints for each transformation and see the results i.e. how are they evaluating in detail between variables,statements and business rules.

SnehaPandey

 Profile Answers by SnehaPandey Questions by SnehaPandey

• Mar 10th, 2011

Divide the main components of graphs having required transformations and do data validation for each of them seperately.

Answer Question  Select Best Answer

kalyanvadlamudi2kn

 Profile Answers by kalyanvadlamudi2kn Questions by kalyanvadlamudi2kn

• Jan 10th, 2014

There are a lot of options in Ab Initio. To get the report at Component level,Graph level ( Log port, AI_SUMMARY files). Ab Initio can even generate reports at the transformation level how many times ...

know_know

 Profile Answers by know_know Questions by know_know

• Feb 21st, 2011

There is a log port in every component available. You can use this port to generate reports.

Answer Question  Select Best Answer