What is mpjret? Explain about the uses of mpjret. How to use mpjret?

khaleel.peace

 Profile Answers by khaleel.peace Questions by khaleel.peace

• Mar 1st, 2011

The variable $mpjret will hold the return status of Abintio graph.Echo $mpjret will tell if the is successful or failed.0 means sucess and any other number means failure.

Answer Question  Select Best Answer

arunsin

 Profile Answers by arunsin Questions by arunsin

• Mar 13th, 2011

Force_error()  function can be used within the xfr to abort the graph. Remeber to keep the transform component with 'Abort on first reject'.Also, specific error messages can be captured from the error port (Never abort).

Answer Question  Select Best Answer

arunsin

 Profile Answers by arunsin Questions by arunsin

• Mar 13th, 2011

Adding to all the point mentioned by others -- Thumb Rule is to prefer componet solution to a problem compared to logical solution.- Use Oracle hints and Ab Initio Hints (ABLOCAL utility for lower ora...

aditya_kundu

 Profile Answers by aditya_kundu Questions by aditya_kundu

• Sep 18th, 2010

I would like to add couple of more points to the already given explanations:1. Try to use lookups for joining instead of join if you have huge no. of records in one flow and relatively less no. of rec...

Answer Question  Select Best Answer

palinindia

 Profile Answers by palinindia Questions by palinindia

• May 20th, 2011

Data Lineage

Answer Question  Select Best Answer

How to insert header and trailer records?

arunfrank1

 Profile Answers by arunfrank1 Questions by arunfrank1

• Jun 6th, 2011

Hi,Keep the header in a separate file, footer in a separate file.flow 1 - headerflow 2 - contentflow 3 traileruse contact with the same flow 1, 2 and 3 and redirect it to the output file.Hope its helpful.ThanksAnne

sham2sushil

 Profile Answers by sham2sushil Questions by sham2sushil

• Jan 22nd, 2011

Use the CONCATENATE component in your graph.--Shambhu

Answer Question  Select Best Answer

How to execute wrappers script?

arunfrank1

 Profile Answers by arunfrank1 Questions by arunfrank1

• Jun 6th, 2011

./.ksh

sham2sushil

 Profile Answers by sham2sushil Questions by sham2sushil

• Nov 15th, 2010

Different methods to run the unix wrapper scripts . ./script_name.sh  sh script_name.sh  ksh script_name.sh  sh -x script_name.sh  ksh -x script_name.sh  Running...

Answer Question  Select Best Answer

How to filter the records by using Reformat?

arunfrank1

 Profile Answers by arunfrank1 Questions by arunfrank1

• Jun 6th, 2011

Thru select

sham2sushil

 Profile Answers by sham2sushil Questions by sham2sushil

• Oct 23rd, 2010

We can also use the Reformat feature output_index and output_indexes. If you have more filter condition then increase the no of count and use the if else condition with the Priority assignment. ...

Answer Question  Select Best Answer

How to do version control in Abinitio?

arunfrank1

 Profile Answers by arunfrank1 Questions by arunfrank1

• Jun 6th, 2011

eme

sham2sushil

 Profile Answers by sham2sushil Questions by sham2sushil

• Apr 28th, 2010

Generally we are doing the version control using the EME (Enterprise Meta Environment).You have to check in or check out the graphs(mp, ksh, dml, dbc, xfr etc files). You can do the check in or check out using GDE or command prompt.--Shambhu

Answer Question  Select Best Answer

What will happen when we pass dot or invlaid parameters in the inout component layout URL?

arunfrank1

 Profile Answers by arunfrank1 Questions by arunfrank1

• Jun 6th, 2011

Hi,I myself found the answer.If the environment parameters are not set, we get this error.--Anne

Answer Question  Select Best Answer

Hi,Can anyone explain how XML reformat is being used to generate XML file.Please let me know with one example.Suppose we have three records in the input file as below:XXX,001,Company_1YYY,008,Company_2zzz,002,Company_3PPP,006,Company_2 where XXX- name001 - Emp IdCompany_1 - Company nameCan anyone help me out to explain the generation of XML using this example.

srihari_vsn

 Profile Answers by srihari_vsn Questions by srihari_vsn

• Jun 20th, 2011

Hi,Let the input file data be as below.PPP,006,Company_2XXX,001,Company_1YYY,008,Company_2zzz,002,Company_3Let the record format for reading this data be as below.recordstring(",") Name;deci...

Answer Question  Select Best Answer

jakirajam

 Profile Answers by jakirajam Questions by jakirajam

• Jul 25th, 2010

"version it"  institute is not  teaching ab initio course;By jakirajam

jakirajam

 Profile Answers by jakirajam Questions by jakirajam

• Jul 25th, 2010

Hello 2.18.32 is new version for co op and 1.18 is new version for GDE.Ok keep it up . By jakirajam

Answer Question  Select Best Answer

how to create a wrapper script in Ab Initio?

Nagesh

• Jul 18th, 2011

Wrapper scripts are used to run the graphs though command prompt
ex
abc.sh
within the abc.sh, we define the graphs ksh like
$/xyz.ksh -param1 -param2.....

then we use the wrapper script(abc.sh) to run the graph from command prompt(unix) using
./abc.sh

i hope this will help you.

Answer Question  Select Best Answer

Mayank

• Jul 18th, 2011

Give the path of .xfr file in AB_DM_DEFS as graph input value parameter.

Mayank Bansalcom

• Jul 18th, 2011

You can include the transform in test. transer using AB_DML_DEFS in Input Value parameter of Graph..

Answer Question  Select Best Answer

After developing the graph what are the step involved to load the EME?

nagarjuna

• Jul 22nd, 2011

After developing graph save it. Automatically it will generate .ksh, .db, .mp, .xfr, .dml.

If you want to send the saved or latest version of the graph you can go for check in option in GDE or From UNIX you can go for EXPORT.

Answer Question  Select Best Answer

What is .pset?

nagarjuna

• Jul 22nd, 2011

.pset is a input parameter file.

arunfrank1

 Profile Answers by arunfrank1 Questions by arunfrank1

• Jun 6th, 2011

Above version 1.15 the inputs which we pass as graph parameters are stored in a file called pset.Its stored in folder pset.Generally pset file will be save as same as graph name with extension .pset--Anne

Answer Question  Select Best Answer

What is Lookup file?

nagarjuna

• Jul 22nd, 2011

Lookup file .dat which contains small amount of data with specified key or keys.

sham2sushil

 Profile Answers by sham2sushil Questions by sham2sushil

• Oct 23rd, 2010

Lookup file is basically a specific dataset which is keyed. This can be used to mapping values as per the data present in a particular file (serial/multi file). The dataset can be static as well dyna...

Answer Question  Select Best Answer

Does sort component read records serial or parellel?

nagarjuna

• Jul 22nd, 2011

It can read both.

chaitugeek

 Profile Answers by chaitugeek Questions by chaitugeek

• Sep 17th, 2010

Sort reads?records in a parallel way, because all?groups of records should read and sorted at a time.

Answer Question  Select Best Answer

What is the need of config variables in abinitio?(ab_job,ab_max_core) and where to define them?

nagarjuna

• Jul 22nd, 2011

For all ab-initio config variables the command starts with AB_

arunfrank1

 Profile Answers by arunfrank1 Questions by arunfrank1

• Jun 6th, 2011

Hi,Its all present in stdenv.ThanksAnne

Answer Question  Select Best Answer

By enabling which parameter, dependency analysis feature get enabled

rakesh

• Aug 17th, 2011

Changes to the above answer ..... In the GDE choose File > Preferences to open the Preferences dialog. Click the Advanced tab, select the Documentation Transforms checkbox and click OK. To set th...

Rakesh

• Aug 17th, 2011

On the GDE menu bar, select File > Preferences.

In the Parameters group of the GDE Preferences dialog, select Document Function.

Open the Properties dialog; in parameter Document Function should be visible.

Answer Question  Select Best Answer

What is Factless Fact?

sree

• Aug 19th, 2011

The fact which is not having any measures(like Quantity) are called factless fact

Answer Question  Select Best Answer