prakirn

 Profile Answers by prakirn Questions by prakirn

• Mar 1st, 2008

GRANT command is used to give permission to users to do or create a specific object in the database.On the other side, REVOKE is used to pull back the permission.Internally these 2 commands make entries into data dictionary tables.

pardip sidhu

 Profile Answers by pardip sidhu Questions by pardip sidhu

• Oct 26th, 2005

Basically,This is a part of D.B.A responsibilities GRANT means permissions for example GRANT CREATE TABLE ,CREATE VIEW AND MANY MORE .           ...

Answer Question  Select Best Answer

sham2sushil

 Profile Answers by sham2sushil Questions by sham2sushil

• May 2nd, 2010

Lookup File consists of data records which can be held in main memory. Lookup is basically a specific dataset which is keyed. This makes the transform function to retrieve the records much faster th...

Ashim Dutta

• Oct 20th, 2005

Lookup 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 dynamic ( ...

Answer Question  Select Best Answer

sekr

 Profile Answers by sekr Questions by sekr

• Apr 13th, 2006

in some cases abinitio will not recognize some part of  sql statments and unable to read the table.. to avoid this we have use AB_LOCAL() and table name when ever we use clauses like WHERE condition

atish_ban

 Profile Answers by atish_ban Questions by atish_ban

• Apr 2nd, 2006

one example is, if you want to use oracle hint in your select query at input table...u should use AB_LOCAL(table) to parse the query at Database sQL engine not by AI parser.It is mainly used at parallel unload.

Answer Question  Select Best Answer

atish_ban

 Profile Answers by atish_ban Questions by atish_ban

• Apr 2nd, 2006

Same as $?....but it will give u return status of mp run cmd...capture and use it at end script to display and notify warning/success and failure msg

sai

• Mar 28th, 2006

U can use $mpjret in endscript likeif  0 -eq($mpjret)thenecho "success"elsemailx -s "[graphname] failed" mailid 

Answer Question  Select Best Answer

sivakrishna

• Jul 6th, 2006

.cfg file is for?the remote connection and .dbc is for connecting the database..cfg contains :1. The name of the remote machine2. The username/pwd to be used while connecting to the db.3. The locatio...

windows

 Profile Answers by windows Questions by windows

• May 29th, 2006

.dbc is database configuration fileand.cfg is database table configuration file

Answer Question  Select Best Answer

naveen

• May 15th, 2006

$#  - No of positional parameters$? - the exit status of the last executed command.

cndraa

• May 13th, 2006

Then what is $# and $? ...

Answer Question  Select Best Answer

sekr

 Profile Answers by sekr Questions by sekr

• Jun 18th, 2006

when you run gde the co-op sys converts the gde into local langg of unix.co-op sys acts like interpretator to operating system.

sudha

• May 29th, 2006

hi sunithawhen ever you press Run button on your GDE,the GDE genarates a scriptand the genarated script will be transfered to your host which is specified in to your GDE run settings. then the Co>o...

Answer Question  Select Best Answer

mukund

• Dec 22nd, 2006

guys,.abinitiorc file contains all configuration variables such as AB_WORK_DIR,AB_DATA_DIR etcthis file  can be find in "$AB_HOME/Config".cheers,mukund

Abhisek Basu Mullick

• Jul 19th, 2006

.abinitiorc is the config file for ab initio. It is found in user's home directory. Generally it is used to contain abinitio home path, different log in information like id encrypted password log...

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

muralidharreddy.v

• Feb 7th, 2007

Hi Vector is nothing but Array's in C. for example Transactions[0] Transactions[1] Transactions[2]Customer ID n dt Amount dt ...

murali

• Aug 30th, 2006

A vector is a sequence of the same type of elements. The element type may be any type including a vector or record type. It is a  field which tell us how many times a particular field is rep...

Answer Question  Select Best Answer

Mukund

• Dec 7th, 2006

 Conditional dml ,is a DML which is separated based on a condition.eg:Suppose ur DML have Header ,detail and Trailer parts,u need to separate these coz we need to have detailed part .record if (r...

Sachin

• Sep 19th, 2006

The DML that is used as a condition is known as conditional DML..Suppose we have data that includes the Header,Main data and Trailer as given below:10 This data contains employee info.20 emp_id,emp_na...

Answer Question  Select Best Answer

Subhra Dhar

 Profile Answers by Subhra Dhar Questions by Subhra Dhar

• Mar 26th, 2009

Join with Database (Join with DB) should not be used if number of records to be?joined with a table is very high as it degrades?performance. Better result can be achieved by retrieving the data from...

K Vijay Kumar

• Oct 28th, 2006

Performing join at database will improve the performance a lot.take a scenario of joining between the two tables. Usally we take two database components and place a join component to perform a join be...

Answer Question  Select Best Answer

mukund

• Dec 22nd, 2006

yeah,error trapping is pretty essential in some cases depending on the business requirement.for components like reformat,join etc we can trap records which are not satisfying the respective rules at r...

Ramana

• Oct 13th, 2006

error trapping each component has reject, error, log ports, reject captures rejected records, error captures corresponding error and log captures the execution statistics of the component. You can co...

Answer Question  Select Best Answer

mukund

• Dec 13th, 2006

Hi, we can give parameters,or any validations which is to be done in the start script of the graphor pass all the necessary parameters as graph parameters or sandbox parameters.these parameters are referenced by a "$" sign.eg:${file_id}=AAA .yuppy,Mukund

K.Vijaya Kumar

• Oct 28th, 2006

creation of input parameters:                  Go to the properties of the graph-->select the parameters tab--&g...

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

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

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

Girivardhana Reddy

• Oct 5th, 2006

 You can truncate the table using one of the following components: Run SQL, Truncate Table, Update Table. 

kalyan

• Mar 16th, 2006

There are many ways to do it. 1. Probably the easiest way is to use Truncate Table 2. Run Sql or update table can be used to do the same thing 3. Run Program

Answer Question  Select Best Answer