phani

• Oct 12th, 2006

for partition by key it internally generates the hash code. through that i distributes the data records.round robin what they said was correct

kalyan

• Mar 16th, 2006

Partition by Key - Distribute according to the key value Partition by Round Robin - Distribute a predefined number of records to one flow and then the same numbers of records to the next flow and so o...

Answer Question  Select Best Answer

seemabuchhada

 Profile Answers by seemabuchhada Questions by seemabuchhada

• Mar 14th, 2014

One table can only have one clustered Index (When we create primary key on table,oracle automatically creates Clustered index on that column) but It can have many non clustered index, approximately 250

Tushar

• Oct 5th, 2007

Clustered Index creates physical order on the table based on the defination given. You can only have one clustered index.

Answer Question  Select Best Answer

pedro

• Jan 13th, 2007

Just to complete the remaining considerations. The outer join, just like the explicit semi joins, will assign null to the non existing fields that should be assigned  by the non existing flows. Therefore lookout for non-nullable fields.

K Nagi Reddy

• May 4th, 2006

If you want to see all the records of one input file independent of whether there is a matching record in the other file or not. then its an outer join.

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

sunilsoni30

 Profile Answers by sunilsoni30 Questions by sunilsoni30

• May 13th, 2008

DBCC is stand for database consistency checker.

babuKishore

 Profile Answers by babuKishore Questions by babuKishore

• Dec 1st, 2006

These statements check the physical and logical consistency of a database. Many DBCC statements can fix detected problems.

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

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

Sandeep Handa

• Feb 21st, 2007

There is a design document for Ab Initio projects just like there is for any project following a software development lifecycle framework. While in some flavors, there is a High level technical design...

shashi_dhar

• Feb 19th, 2007

I am able to understand ur question. there is no sch kind of document in abinitio.The design document is project related.Regards,Shashi

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

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

Murali Padala

• Dec 5th, 2011

Continuous flows can be used to enable real time processing in abinitio.

vikki_gupta2003

 Profile Answers by vikki_gupta2003 Questions by vikki_gupta2003

• Mar 14th, 2007

Hi,I think it depends upon the bussiness logicpr whether it is one to one mapping.ODS to Staging is smwhat which depends upon the various logics.

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

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

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

sree

• Dec 11th, 2006

Hi ,We can do it by using PARTITON BY KEY AND SORT COMPONENT.Sree

balaji

• Jun 9th, 2006

hello,To convert 4 way to 8 way partition we need to change the layout in the partioning component. There will be seperate parameters for each and every type of partioning eg. AI_MFS_HOME, AI_MFS_MEDI...

Answer Question  Select Best Answer

Balaji

• Jul 12th, 2006

  for design your graph as a parameterised  you should declare the parameter scope "formal"     Thanks,  Balaji Venigalla

prabhupurna

 Profile Answers by prabhupurna Questions by prabhupurna

• Jul 7th, 2006

One of the main purpose of the parameterized graphs is that if we need to run the same graph for n number of times for different files, we set up the graph parameters like $INPUT_FILE, $OUTPUT_FILE et...

Answer Question  Select Best Answer

What is Standarad Environment? What it contains?

sixto.dsilva

 Profile Answers by sixto.dsilva Questions by sixto.dsilva

• Apr 17th, 2008

standard environment is the ab initio environment that has more then one private project and also other public project , in addition to the required environment project.Private project is one which no...

surabhiraghu

 Profile Answers by surabhiraghu Questions by surabhiraghu

• Jan 2nd, 2008

  std env is nothing but collection of public & private & environment project.

Answer Question  Select Best Answer

mukund

• Dec 15th, 2006

Hey folks,  If there is any instance of having dynamically changing dml's,then we have to pass both dml's as well as xfr's as graph parameters.cheers,Mukund

Arvind

• Jun 23rd, 2006

I Think we can use MULTIREFORMAT component to handle dynamically changing DML's

Answer Question  Select Best Answer

lakshmipavany.g

 Profile Answers by lakshmipavany.g Questions by lakshmipavany.g

• Jun 25th, 2008

Hi EME is like All-In one guide, where as Sand box is an idividual subjected guide restricted for individual user.Check in/ check out are the procedure to send/extract graphs from sandbox to EME....

sivakrishna

• Jul 6th, 2006

The project is under source control under EME. You can't do any manipulations on the project which is in EME. So if you want to do any manipulations you have to check out the project into your sandbo...

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