-
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.
-
Parameter Sets
What is the structure of parameter sets?
-
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
-
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.
-
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 ...
-
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
-
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...
-
Abinitio Partition Component
What is the optimistic partitioning component in abinitio? How can we say that it is an optimistic partition component?
-
Most Common Runtime Errors
Give some runtime errors which are commonly comming in your graph execution?
-
Reformat Component
What is use of index in Reformat Component?
-
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.
-
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).
-
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...
-
-
Insert Header and Trailer
How to insert header and trailer records?
arunfrank1
- Jun 6th, 2011
Hi,Keep the header in a separate file, footer in a separate file.flow 1 - headerflow 2 - contentflow 3 traileruse contact with the same flow 1, 2 and 3 and redirect it to the output file.Hope its helpful.ThanksAnne
-
UNIX Wrapper Script
How to execute wrappers script?
sham2sushil
- Nov 15th, 2010
Different methods to run the unix wrapper scripts . ./script_name.sh sh script_name.sh ksh script_name.sh sh -x script_name.sh ksh -x script_name.sh Running...
-
Records Filter
How to filter the records by using Reformat?
sham2sushil
- Oct 23rd, 2010
We can also use the Reformat feature output_index and output_indexes. If you have more filter condition then increase the no of count and use the if else condition with the Priority assignment. ...
-
Version Control in Abinitio
How to do version control in Abinitio?
sham2sushil
- Apr 28th, 2010
Generally we are doing the version control using the EME (Enterprise Meta Environment).You have to check in or check out the graphs(mp, ksh, dml, dbc, xfr etc files). You can do the check in or check out using GDE or command prompt.--Shambhu
-
Invalid Paramenter in Layout URL
What will happen when we pass dot or invlaid parameters in the inout component layout URL?
arunfrank1
- Jun 6th, 2011
Hi,I myself found the answer.If the environment parameters are not set, we get this error.--Anne
-
XML Reformat
Hi,Can anyone explain how XML reformat is being used to generate XML file.Please let me know with one example.Suppose we have three records in the input file as below:XXX,001,Company_1YYY,008,Company_2zzz,002,Company_3PPP,006,Company_2 where XXX- name001 - Emp IdCompany_1 - Company nameCan anyone help me out to explain the generation of XML using this example.
srihari_vsn
- Jun 20th, 2011
Hi,Let the input file data be as below.PPP,006,Company_2XXX,001,Company_1YYY,008,Company_2zzz,002,Company_3Let the record format for reading this data be as below.recordstring(",") Name;deci...
Abinitio Interview Questions
Ans