-
-
How do you improve the performance of a graph?
arunsin
- Mar 13th, 2011
Adding to all the point mentioned by others -- Thumb Rule is to prefer componet solution to a problem compared to logical solution.- Use Oracle hints and Ab Initio Hints (ABLOCAL utility for lower ora...
aditya_kundu
- Sep 18th, 2010
I would like to add couple of more points to the already given explanations:1. Try to use lookups for joining instead of join if you have huge no. of records in one flow and relatively less no. of rec...
-
Explain how the graph can be aborted at runtime by using it in the xfr.
arunsin
- Mar 13th, 2011
Force_error() function can be used within the xfr to abort the graph. Remeber to keep the transform component with 'Abort on first reject'.Also, specific error messages can be captured from the error port (Never abort).
-
What is mpjret?
What is mpjret? Explain about the uses of mpjret. How to use mpjret?
khaleel.peace
- Mar 1st, 2011
The variable $mpjret will hold the return status of Abintio graph.Echo $mpjret will tell if the is successful or failed.0 means sucess and any other number means failure.
-
Reformat Component
What is use of index in Reformat Component?
-
Most Common Runtime Errors
Give some runtime errors which are commonly comming in your graph execution?
-
Abinitio Partition Component
What is the optimistic partitioning component in abinitio? How can we say that it is an optimistic partition component?
-
Replicate and Broadcast Components
When can we go replicate and when we cannot go broadcast components?What is the advantage & disadvantage of replicate?What is the advantage & disadvantage of broadcast?
sham2sushil
- Nov 15th, 2010
Broadcast - Takes data from multiple inputs, combines it and sends it to all the output ports. For example, You have 2 incoming flows (This can be data parallelism or component parallelism) on Bro...
-
DB Lookup
How do you use DB Lookup?
sham2sushil
- Oct 26th, 2010
For DB Lookup you can use the componant Join with DB. This is very expensive operation in the Abinitio. If Join table caontain less data then first create a serial file and use as a lookup. OR go for abinitio Join.--Shambhu
-
Broadcast Vs Replicate
What is the functional difference between Replicate and Broadcast component?
sham2sushil
- Oct 26th, 2010
In General:Broadcast : Data parallelism.Replicate : Component parallelism.--Shambhu
abmaahi
- Jul 19th, 2010
1) Basic difference is broad caste is partition component and replicate is miscelleanous component.2) As broad cast is partition component it always defaultly throw in a fan out mode only where ...
-
Size of the file
Which component will be used to reduce the size of the file?
sweetramy
- Oct 7th, 2010
You can use the Compress or Deflate component to reduce the size of the file.
-
What is Pset file in Abinitio?
sham2sushil
- Oct 23rd, 2010
.pset file is an input values or input parameters set file. By using the air sandbox run command we can run the .pset file. Internally calling the .mp file and passing all the inputs parameter during run time.--Shambhu
-
Parameter Sets
What is the structure of parameter sets?
-
Graph Deployment
Explain the deployment of graph, with start and end script?
kalrac
- Jul 19th, 2010
Thanks for the response,My actual question is when there is a start script and end script. When the execution starts from start script > graph>end script. But the deployed ksh in unix is not of ...
abmaahi
- Jul 19th, 2010
Basically when we execute the graph first start script are executed before graph and later end scritpt is executed in the GDE.
-
Wrapper Scripts
What are Wrapper scripts? What does it contain?
abmaahi
- Jul 19th, 2010
Wrapper scripts are unix scripts,they also known as calling scripts.they used to run the deployed scripts.in the order what se can specify in the unix script
-
What is the function you would use to transfer a string into a decimal?
venkat_jaksani
- Jun 17th, 2010
If string conains the alphanuemica data the decimal-strip will remove the alpanumeric data but the decimal(length) will not remove alphanumeric data.Please let me know If I am wrong.
abmaahi
- Mar 29th, 2010
Decimal_lrepad(string name, decimaldata type length) decimal_lpad(string name, decimaldata type length)
-
What is the difference between a DB config and a CFG file?
venkat_jaksani
- Jun 18th, 2010
.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 stuffs l...
dash_c00l
- Oct 31st, 2007
.dbc file basically helps abinitio coops to connect to database. It includes all the required database parameter and other default value respective to it. you can modify them.However .cfg is file is u...
-
Explain the differences between api and utility mode?
abmaahi
- Jun 12th, 2010
API mode is for more diagnostic purpose for retriving the data from db means like selecting perticular fields, like retriving the data relatively according to the constraints. Whenever we select...
subhajitpalit
- Dec 11th, 2009
In API mode the data processing(load/update/insert/delete) is slow, however other process can access the database tables during the update.Compared to above, Utility mode processing(load/update/insert...
-
SCD Types
How do we use SCD Types in the Abinitio graphs?
sudheer_abinitio
- Jun 8th, 2010
We phase 3 types of SCD.1. SLOWLY CHANGES DIMENSION TYPE 1 Having the current data. Latest data. Ex: 1 Record only 2. SLOWLY CHANGES DIMENSION TYPE 2 ...
abmaahi
- Apr 6th, 2010
Sorry the before answer is wrong.we can work out the scds with redefining the formats
-
Compilation Errors
What are the compilation errors you came across while executing your graphs?
hsevna
- May 18th, 2010
If fan-in is used to the input flow of a Roll-up component, you will get a complilation error, though sort rquired is set false to the Roll-up.Correct me if i'm wrong.--Anvesh V.
sham2sushil
- May 7th, 2010
Scenario 1: When you built any graphs with Abinitio component, but the output DML is not same with the next component input port DML, then you will get the compilation errors. Scenario 2: Suppose...
Abinitio Interview Questions
Ans