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

How does one make use of the "Call Web Service" component in the $AB_HOME/connectors/Internet directory of the component selector window of the Ab Initio Console? Explain with Sample Code

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

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

Mahendra

• Feb 13th, 2007

Hi Pradeepa,I never worked on Informatica... but as per my knowledge concern the main difference between these two is In Ab initio you can do data parallelism, which ultimately helps to save ur time t...

PRADEEPA

• Jan 11th, 2007

1.abinitio holds parallelism2.mulitifile system 3.amount of data migration is more in abinitio.4.easy to run & bulid.

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

chandan

• Feb 7th, 2007

In SW world fencing means job controlling on priority basis. In AI it actually refers to customized phase breaking. A well fenced graph means no matter what is source data volume process will not cough in dead locks. It actually limits the number of simultaneous processes.

Rajeev M Sankarathil

• Dec 6th, 2006

I think he is refering to "Phasing" only.Phasing:- Its a way to manage the resource and avoid "deadlocks" in the Abi run. it limits the number of simultaneous processes by breaking up the graph into different phases, only one of which is running at any given time.

Answer Question  Select Best Answer

mahendra patnaik

• Feb 5th, 2007

Hi,EME contains only the latest version graphs of your project. It is a area where single or multiple projects will stored. for checkin or check out the graph into the EME you have to look on to the...

sekhu

• Dec 22nd, 2006

sandbox --> is the personal work area and u will find only latest vesrons of the graphs.eme is like vss ! there u will find old and new versions of the graphs.when u check in / out the graph that will come into your sandbox area.hope this will help you..

Answer Question  Select Best Answer

mahendra patnaik

• Feb 1st, 2007

Hi,you can achive this by using one component called record validation... it will use only if u want to validate the input record... if you want to validate field lavel values then there are some func...

Abinitio Geek

 Profile Answers by Abinitio Geek Questions by Abinitio Geek

• Jan 27th, 2007

What exactly is your requirement? Can you specify that, as there are various other functions available apart from the more common ones like is_valid(as you had mentioned), is_null, is_blank and is_defined. Besides which, there are comparison operators available like any other programming language.

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

mukund

• Dec 26th, 2006

Hi,lookup_local funtion retrieves the first matching record from a partitioned multifile,which is partitioned on a particular key.consider a lookup file "emp_detail" which is having the fields emp_id,...

vpnreddy

 Profile Answers by vpnreddy Questions by vpnreddy

• Nov 7th, 2005

Lookup File consists of data records which can be held in main memory. This makes the transform function to retrieve the records much faster than retirving from disk. It allows the transform component to process the data records of multiple files fastly.VPN Reddy

Answer Question  Select Best Answer