-
What is the purpose of having stored procedures in a database?
nithui
- Mar 11th, 2009
1. It is used to increases the performance of the application. Because when we create Store procedure, they are compiled and stored in database. Later when applications call them, they are general...
sreyas kvm
- Feb 9th, 2008
Stored procedure is a pre-compiled execution block,so they do not want to wait as the time for compilation.It is call from the server.It reduce the execution time
-
-
How can we test the abintio manually and automation?
Nikhil
- Aug 19th, 2015
How can we integrate Ab Initio with Jenkins. Have you done anything like that or read about it. I want to integrate them.
robbyuk
- Mar 27th, 2013
Hi All,
I appreciate I am a late entry for this question. I think tools like Jenkins can be used for Ab Initio automation test harness. Please correct if I am wrong. -
Removing Header and Trailer Records
How to remove Header and Trailer records from a file using abinitio components?
-
What command would you use to inspect the users currently logged into SQL Server database?
titli_n_titli
- Aug 14th, 2009
The below SQL Query can solve the purpose:select username from V$SESSION;
-
What is Vector Field? Explain.
arpit mathur
- Sep 29th, 2011
Hi Can u please explain it with example, i need to build the vector for comparison of the inputs records , if that records matches then i take the output
annegrace1
- Apr 8th, 2009
Vector field is like an array which is used in C/C++.Its mainly used in normalize and denormalize component.
-
What are the different schedulers used for running the abinitio graphs
abhi_fresh_as_dew
- Sep 8th, 2008
You can do anything in Ab Initio, depends on the logic you useSay there are 10 jobs 1,2,3,4,5 .. 10 and all the graphs are deployed as script.Suppose 1-4 graps should run at the same time and sequenti...
sreenivasamurthy
- Jun 19th, 2007
In ab initio there are no specific scheduling options as in informatica. What we can do is use cronjob options as in unix
-
What is EME?
sixto.dsilva
- Aug 1st, 2008
As explained by Abishek, EME is the data repository(Datastore's data files)?as well a version controller compoent of ab initio software. It keeps track of obhects such as graph, dml, xfr, ksh and sq...
sreenivasamurthy
- Jun 20th, 2007
EME stands for Enterprise Meta Environment. It is nothing but like a repository in Informatica. It contains all the metadata i.e data related to graphs, dml, xfr, etc. It performs the following func...
-
How to handle if DML changes dynamically in abinitio
annegrace1
- Apr 6th, 2009
Give the parameters using edit parameter and make it as formal parameter that is run time parameter.Then in the DML eg. $AI_DML/abc_$parameter1.dmlAccording to the value of the parameter that particular DML will be called.
Guru
- Sep 4th, 2007
If DML changes dynamically in source we can handle it using "Conditional DML'But how it can be achieved in "parameterisation" and using "metadata". Please explain?
-
How to take the input data from an excel sheet?
N MAHAMMAD RAFI
- Nov 24th, 2006
Hi GUYS, COMPONENTS>TRANSALATE>READ SAPARATED VALUES component ... U CAN USE THIS EXCEL FOR EXCEL SHEET...................THANKSRAFI CHENNAI
-
How Does MAXCORE works?
prabhupurna
- Jul 8th, 2006
Every component in Ab initio has a memory of 7MB (anybody correct me if I'm wrong) except a few components like In-Memory components such as join, Rollup, Scan, join with DB etc., which uses an a...
atish_ban
- Apr 2nd, 2006
It is maximum temporary scratchpad memory allowed for execution of a in-memory component/per partition.
-
Hi !I have worked on datastage and informatica ..we have option called report where we can generate the complete job ryt from components to code ..i want know ab-initio does it have facility of job report.
kalyanvadlamudi2kn
- Jan 10th, 2014
There are a lot of options in Ab Initio. To get the report at Component level,Graph level ( Log port, AI_SUMMARY files). Ab Initio can even generate reports at the transformation level how many times ...
know_know
- Feb 21st, 2011
There is a log port in every component available. You can use this port to generate reports.
-
What is the lookup function used to retrieve the particular duplictae datarecords in the lookup file
abhi_fresh_as_dew
- Jun 29th, 2009
Use lookup_count for finding the duplicates and lookup_next for retrieving it.If lookup_count (string file_label, [ expression [ , expression ... ] ] )>0lookup_next ( lookup_identifier_type lookup_id, string lookup_template ) Njoi!!Abhi - fresh as dew!
pradeep
- Nov 16th, 2006
Lookup_next function is used for retrieving duplicates records of that particular record
-
How to identify the Ascii , Ebcdic formats !how to write the DMl for same ..please explain ..
abhi_fresh_as_dew
- Feb 3rd, 2010
For ASCII formats write the DML as below.cust_id decimal(8)...For EBCIDIC formats write the DML as below.ebcidic cust_id decimal(8)...The delimiters varies in each and every ebcidic formats send from source files. But Its generally hexadecimal embedded.
AprilBlue
- Jan 10th, 2007
Ascii vs. EbcdicWhen you view your data does it have different charaters inbetween that do not look ASCII? If so, then in your record format type the following:ebcdic record record details...
-
-
Input Table component layout - Abinitio
My question is related to the INPUT TABLE component layout. If we select the layout to be DATABASE- (database default), where exactly is it pulling that layout from? When should this option be used? Within the DATABASE layout we also see the SERIAL ,TABLE and EXPLICIT args options, when do we use those? what are the advantages and disadvantages to this approach? Thanks
annegrace1
- Apr 8th, 2009
I would suggest you not to use the default database. either ai_serial or ai_mfs.Default database will pick the data from the database in the same structure as it is in db.The data in db might be serial or partition.
ankithak
- Oct 13th, 2007
Hi mahindra , I didnt get ur answer .If u dont mind pls give me clear explanation with example.
-
What are the commonly used or important functions used in the real time in Abintio
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
-
How do you join two files with different layouts
sitharaju
- Mar 11th, 2009
I think your question is to join a serial file and a multifile,?if that is the case use broadcast component after the serial file and before join.
Shilpi
- Aug 12th, 2007
If the layout is?totally different ----use Fuse Component
-
What is lock in abinitio?
SP
- Aug 31st, 2017
Lock is a version control mechanism in Abinitio. It is used to maintain data/code synchronization between EME and multiple sandboxes. It avoids to modifying the code simultaneously be different users at the same time.
sixto.dsilva
- Apr 18th, 2008
Lock mechanism is used by EME datastore to avoid confusion in the version control of a graph basically locking give a exclusive permission to modify and save it for a particular users and prevents other from making changes to the same file.
-
Explain real time environment of Ab initio?
pullarao
- Jan 16th, 2015
How to capture the delete records in abinitio
Abinitio Interview Questions
Ans