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

 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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

To run a graph infinitely, the end script in the graph should call the .ksh file of the graph. Thus if the name of the graph is abc.mp then in the end script of the graph there should be a call to abc.ksh. Like this the graph will run infinitely.

prakirn

 Profile Answers by prakirn Questions by prakirn

• Mar 1st, 2008

You can use "Continious flow" components for this

Sai

• Jun 29th, 2006

I wonder why u require this Infinite loop concept if so how to get out if a graph runs recursively..

Answer Question  Select Best Answer

What are air-project parameters and air-sandbox? What does it contains?

sixto.dsilva

 Profile Answers by sixto.dsilva Questions by sixto.dsilva

• Mar 4th, 2008

as we know a sandbox is filesystem which contains all the graphs and other file that graphs depend on. when sandbox contents are put under sourc control in EME datastore it becomes project. Now sanbox...

Answer Question  Select Best Answer

rcoon7

 Profile Answers by rcoon7 Questions by rcoon7

• Mar 10th, 2008

dynamic DML is used if the input metadata can change i.e. suppose at different time different input files are recieved for processing which have different dml.in that case we can use flag in the dml a...

Answer Question  Select Best Answer

When did we get error like 'Bad-Straight-flow'?

sixto.dsilva

 Profile Answers by sixto.dsilva Questions by sixto.dsilva

• Apr 15th, 2008

It is error you get when there is mismatch in flow that is one is serial flow and other componet is mfs flow , the ab initio will complain about the bad flow and graph is will be aborted because of this. you should be using the partition component in order to avoid this.

rcoon7

 Profile Answers by rcoon7 Questions by rcoon7

• Mar 10th, 2008

Layouts problems in components. e.g. a straight flow connecting a component which is having serial layout with a component which is in muti-file layout.

Answer Question  Select Best Answer