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

prakirn

 Profile Answers by prakirn Questions by prakirn

• Mar 1st, 2008

As per database point of view, checkpoint is used to flush the data from DB buffer (memory) to the physical disc.

sreenivasmurthy

• Jun 19th, 2007

As per my knowledge in abinitio checkpoints are the intermediate stopping points. These will save information about the recent processed data in the form of *rec files. so whenever there?occurs a?...

Answer Question  Select Best Answer

ghoshkunal123

 Profile Answers by ghoshkunal123 Questions by ghoshkunal123

• Feb 4th, 2008

.dbc file contains all the connectivity info which the user needs to connect to the database. dbc means database configuration file. It will contain the server name, userid, password, type of db, stuf...

prabhupurna

 Profile Answers by prabhupurna Questions by prabhupurna

• Sep 7th, 2006

.cfg file is for remote connection and .dbc file is for database connection.

Answer Question  Select Best Answer

basuatrayee

 Profile Answers by basuatrayee Questions by basuatrayee

• Jan 30th, 2008

There can be numerous sandboxes for a project but there should be only one sandbox associated with EME for a project.

surabhiraghu

 Profile Answers by surabhiraghu Questions by surabhiraghu

• Dec 31st, 2007

We can have any no of sandboxes, sand box is nothing but users work area where each user  will get copy of the project & do the modifications acc.

Answer Question  Select Best Answer

rajraku

 Profile Answers by rajraku Questions by rajraku

• Jan 23rd, 2008

While creating table you can implement tat by addingforeign key references p.tab_name(p.Col_name)heree p refers primary table andd this statement to be written beside col you want make as refrential integrity for the table.....................

Answer Question  Select Best Answer

surabhiraghu

 Profile Answers by surabhiraghu Questions by surabhiraghu

• Dec 31st, 2007

It  is possible with help of EME. it follows UNIX file structure.

Answer Question  Select Best Answer

gettoknow

 Profile Answers by gettoknow Questions by gettoknow

• Dec 2nd, 2007

Cursor are database objects used by theaplication to manipulate the data in a set row by row basis

sraam

• Jan 17th, 2006

Ab intitio doesnt uses cursors. it can fetch any number of records simultaneously.

Answer Question  Select Best Answer

anji_abinitio

• Nov 20th, 2007

API and utility are two possible interfaces to databases from Abinitio.we might use API mode when you want to make use of a function that is not available throgh a utility.

sreenivasamurthy

• Jun 19th, 2007

These are the interfaces to the database.api is more advantageous than utility.api use the sql queries where as the utility uses the options provided by the vendor

Answer Question  Select Best Answer

PRiyunkha

• Nov 20th, 2007

Connecting two different servers in Abinito is done thorugh a file called abinitio.rc. This is used for remote connectivity. This file contains information like the server ip(or name),the user name and the password required to connect.

Answer Question  Select Best Answer

ankithak

 Profile Answers by ankithak Questions by ankithak

• Oct 13th, 2007

 1)     In abinitio component,pipeline parallesim supports default.so the user cant change it. so for data parallesim supports only when ur  graph has muitifiles wit...

Answer Question  Select Best Answer

Gaurav Rustogi

• Sep 7th, 2007

Explicitly chooses an index scan for the specified table. You can use the INDEX hint for domain, B*-tree, and bitmap indexes.CREATE INDEX ix_customers_genderON customers(gender);set autotrace traceonl...

siddharth ranga

• Sep 29th, 2005

an eg for hints:Direct use of indexes.select /*+ index(a index_name) full(b) */ *from table1 a, table2 bwhere b.col1 = a.col1 and b.col2= 'sid'and b.col3 = 1;

Answer Question  Select Best Answer

Sachin

• Sep 4th, 2007

There are many ways to improve the performance of the graph. It also depends on a particular graph, the components used in it. In general the following tips can be used for improving perform...

prakash

• Aug 9th, 2006

hi sunny,wat u said is right.

Answer Question  Select Best Answer

Is there a way of implementing File Listener in Abinitio? It should continuously scan a given directory, as soon as a file is placed in that directory, it should copy that file to a working directory and trigger a corresponding Abinitio graph

Abhijit Jagtap

• Jul 12th, 2007

You can use the CONTINOUS components to build this. It requires and environment setup though. You can read through the Ab Initio help by searching on 'Continuous graphs'.

Answer Question  Select Best Answer

Kiran SS

• Jul 6th, 2007

Provided the DML is same you can directly connect both input and output datasets and perform and extract and load operation. For example, If the input dataset is a table and output is file, you can directly connect both these, making sure the DML of the file is propagated from table.

Answer Question  Select Best Answer

sreenivasamurthy

 Profile Answers by sreenivasamurthy Questions by sreenivasamurthy

• Jun 20th, 2007

It is possible to write a stored procedure in abinitio. Just write the stored procedure?and save it but do not forget to use the stored procedure with recompile option because it will improve the performance.

Mahendra

• Mar 1st, 2007

Yes it is possible to call a stored procedure in Ab Initio. to call a stored procedure first of all you have to write a stored procedure and store it , then use one input component to call a stored procedure .

Answer Question  Select Best Answer

sreenivasamurthy

 Profile Answers by sreenivasamurthy Questions by sreenivasamurthy

• Jun 20th, 2007

Normally to maintain short term historical data llike 3-6 months etc. there is no need to go to DWH. For maintaining long ternm historical data i.e., 3-6 years etc., You need to go to DWH. In DWH we w...

ankur

• May 26th, 2007

We can have active and inactive records in data warehouse to maintain history.

Answer Question  Select Best Answer

sreenivasamurthy

• Jun 19th, 2007

Lookups are always used with combination of the reformat components. In business rules you write the lookup function and use look up. You can find lookup button in the description tab of the editor.

ananya

• Mar 12th, 2007

If you have a already saved lookup file in some specific path, just call that file in the graph.You can do that by using a 'lookup file' component in the graph, whose URL will have the path of the loo...

Answer Question  Select Best Answer

Satish Kumar

• Jun 9th, 2007

Hi Praveen,In Ab Initio there is no In Built Schedular in the GDE...Most of them are using cron tab or specific tools for scheduling 1)AutoSys or2)Maestro.

ramu

• Feb 19th, 2007

You dont have schedule in abinitio unlike informatica here in this tool we need to buy the third party tool namely autosys for scheduling

Answer Question  Select Best Answer

Beedi

• Mar 18th, 2007

No its not possiable to transaction of CICS in AbInitio Graph, because Mainframe has limited data gateway connectivity via AbInitio it just uses the layout. You have to get the stuff from Mainframe to Abinitio and carry on your transaction.

Answer Question  Select Best Answer

vijayk07

 Profile Answers by vijayk07 Questions by vijayk07

• Mar 13th, 2007

String_ltrim,string_lrtrim,string_substring,reinterpret_as,

Mahendra

• Feb 13th, 2007

Hi Hema,I am not able to understand what is your requirement... see there are lot of functions available in the Ab Initio so we can not decide which function will be commonly used in Ab initio.. regards,mahendra

Answer Question  Select Best Answer