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

What are environment variable? Why are they required?

annegrace1

 Profile Answers by annegrace1 Questions by annegrace1

• Apr 8th, 2009

Environment Variables or other wise know as ABINITIO environment variable. Its set in stdenv under which private project and pubic project will be there.Parameters like $AB_HOME , $AB_AIR_RROT will be present in environment variable and this will link to the relational path respectively

Answer Question  Select Best Answer

What data modelling do you follow while loading of data to tables? Also the DB you are inserting the data has Star schema or Snow flake schema?

kalyanvadlamudi2kn

 Profile Answers by kalyanvadlamudi2kn Questions by kalyanvadlamudi2kn

• Jan 12th, 2014

It depends on schema, since the star/snow flake schema has one fact table attached to multiple dimensions
so, I would go with 3rd normalized form.

Answer Question  Select Best Answer

What is the advantage of SORT within GROUP Clause?

veerahkvr

 Profile Answers by veerahkvr Questions by veerahkvr

• Aug 22nd, 2009

Sort within Groups refines the sorting of data records already sorted according to one key and it sorts the records within the groups formed by the first sort according to a second key.

Answer Question  Select Best Answer

sham2sushil

 Profile Answers by sham2sushil Questions by sham2sushil

• Apr 27th, 2010

It reduces the number of processes created by the graph and can enhance performance of the graphs. It is combined saveral graph componants at a time in a group during run. groups runs as a single process and use the less memory during runtime.--Shambhu

Answer Question  Select Best Answer

What is Range Lookup?

sham2sushil

 Profile Answers by sham2sushil Questions by sham2sushil

• May 2nd, 2010

Its returns the first data record When you defined the range indicated by the lower and upper bound arguments. --Shambhu

Answer Question  Select Best Answer

What is "Package" and "Package Editor" and how and why it is used.

hari.pardha

 Profile Answers by hari.pardha Questions by hari.pardha

• Dec 18th, 2011

Once you log in to transform editor click on view and go to package editor. It is used to have extra tranform abilities like intialise, finalise etc

Answer Question  Select Best Answer

How to pass force_error with condition?

DilipPanda

 Profile Answers by DilipPanda Questions by DilipPanda

• Apr 4th, 2010

You can write force_error function in following fashionout:reformat(in)beginif (in.cust_name=="XYZ") force_error("Invalid Customer");out.*::in.*endHope this helps...

Answer Question  Select Best Answer

How to convert 4 way to 8 way mfs files without throw down of data in the file?

sham2sushil

 Profile Answers by sham2sushil Questions by sham2sushil

• Apr 27th, 2010

1. To convert 4 way to 8 way partition we need to change the layout in the partioning component.2. Departition the data then repartition.--Shambhu

Answer Question  Select Best Answer

Why wrapper scripts are used in job scheduler to run graphs in Ab Initio? Why cannot we use .ksh script in Job scheduler to schedule job?

chekri

• Oct 6th, 2011

Wrapper Script executes multiple graphs(or) jobs,that means multiple .ksh jobs are going to execute here,
where coming to .ksh which will be execute a single component process. that means every component process having the .ksh process

Answer Question  Select Best Answer

What are Wrapper scripts? What does it contain?

abmaahi

 Profile Answers by abmaahi Questions by abmaahi

• Jul 19th, 2010

Wrapper scripts are unix scripts,they also known as calling scripts.they used to run the deployed scripts.in the order what se can specify in the unix 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

sham2sushil

 Profile Answers by sham2sushil Questions by sham2sushil

• Oct 23rd, 2010

.pset file is an input values or input parameters set file. By using the air sandbox run command we can run the .pset file. Internally calling the .mp file and passing all the inputs parameter during run time.--Shambhu

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

How do you use DB Lookup?

sham2sushil

 Profile Answers by sham2sushil Questions by sham2sushil

• Oct 26th, 2010

For DB Lookup you can use the componant Join with DB. This is very expensive operation in the Abinitio. If Join table caontain less data then first create a serial file and use as a lookup. OR go for abinitio Join.--Shambhu

Answer Question  Select Best Answer

Which component will be used to reduce the size of the file?

sweetramy

 Profile Answers by sweetramy Questions by sweetramy

• Oct 7th, 2010

You can use the Compress or Deflate component to reduce the size of the file.

Answer Question  Select Best Answer

How to get sort data in i/p by using single component in abinitio?

siva sankar pulivarthi

 Profile Answers by siva sankar pulivarthi Questions by siva sankar pulivarthi

• Dec 28th, 2011

You can use sort component to get the sorted output.

--
Siva Sankar Pulivarthi

Answer Question  Select Best Answer

How can we login into the abinitio as a developer?

puneetdking

 Profile Answers by puneetdking Questions by puneetdking

• Sep 30th, 2011

If u have access to Development server provided by the firm u r working with, then you can log in as developer by giving host name (Dev server name), host type, connection method, your login id and password from Settings > Manage connection menu in abinitio tool

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