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

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

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

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

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

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

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

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

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

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

palinindia

 Profile Answers by palinindia Questions by palinindia

• May 20th, 2011

Data Lineage

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

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

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

What is use of index in Reformat Component?

priyanka2000

 Profile Answers by priyanka2000 Questions by priyanka2000

• Jan 8th, 2011

Output_indexes in Reformat functions like a Partition.

Answer Question  Select Best Answer

Give some runtime errors which are commonly comming in your graph execution?

dilipkumar291

 Profile Answers by dilipkumar291 Questions by dilipkumar291

• Dec 15th, 2010

Nerver abort

Answer Question  Select Best Answer

What is the optimistic partitioning component in abinitio? How can we say that it is an optimistic partition component?

dulamuday

 Profile Answers by dulamuday Questions by dulamuday

• Dec 9th, 2010

Partition by Round Robin is Optimistic Component, by using data skew we can say that it is optimistic component

Six face

 Profile Answers by Six face Questions by Six face

• Nov 29th, 2010

Round Robin is the optimistic partition.

Answer Question  Select Best Answer

When can we go replicate and when we cannot go broadcast components?What is the advantage & disadvantage of replicate?What is the advantage & disadvantage of broadcast?

sham2sushil

 Profile Answers by sham2sushil Questions by sham2sushil

• Nov 15th, 2010

Broadcast - Takes data from multiple inputs, combines it and sends it to all the output ports. For example, You have 2 incoming flows (This can be data parallelism or component parallelism) on Bro...

Answer Question  Select Best Answer