-
What is a control file in abinitio?
siva sankar pulivarthi
- Feb 9th, 2012
In Abinitio, we have Multifile System. Multifiles are like different partitions of an original file. For example, if we take a 4 way partition file, which implies, data of an original file is stored i...
-
Abinition Multi file Conversion
How will you convert 8 way mfs to 10 way mfs for multi files?
chandu
- Feb 7th, 2012
We can use re-partition component just like partition by key & sort. In that layout we can change the depth.
AsheshN
- Feb 2nd, 2012
We can simply use any partition component (partition by key, round robin or anything) to achieve this. Just Specify the target multi file system location in the layout of the partition component. There you go!!
-
Inner Join
What will be output for Inner join having no key when I/P in two respective Input Ports are:-
Input1 = 1,1 (one record with two fields)
Input2 = 1,1,1 (one record with three fields)?
vijayv
- Feb 3rd, 2012
Yes, this is wonderful scenario.
in0:1,1
in1:1,1,2
when we are using inner join wil get 4 records
(1,1)(1,1)(1,1)(1,1).
when we are using cartesian join (with out key) wil get 6 records.
i.e. 2 X 3 records....(1,1)(1,1)(1,2)(1,1)(1,1)(1,2) records.
Thank youP N Reddy
- Jan 12th, 2012
Yes you will get only one record when you have not given any key in join that will give you the cartisean product. since you have the inputs as in0-1record and ina-1record 1 cross 1 is 1. the output ...
-
How we can create job sequencer in abinitio i.e running number of graphs at atime
PN Reddy
- Jan 12th, 2012
Yes by using Plans we can make the jobs to run in sequence. means the output of the abc.mp graph is input for xyz.mp. and also by using Autosys or Control M we can schedule the jobs with proper dependencies.
tanuj_06
- Jul 9th, 2011
There is something called Conduct IT...Plans where u can schedule multiple graphs in abinitio...
-
Which file should we keep it as a look up file, large file or less data records file & why?
Ram
- Jan 9th, 2012
When we say lookup, it can be in serial or it can in MFS and generally based on the application logic we decide what kind of lookup it needs to be. And again we need to think on the natire of the loo...
siva sankar pulivarthi
- Dec 28th, 2011
Lookup File should be of small size or less number records. This is because, when the graph is invoked, all the data in the lookup file file will be loaded into memory..This means..if the data in the...
-
Abinitio Sorted Component
How to get sort data in i/p by using single component in abinitio?
siva sankar pulivarthi
- Dec 28th, 2011
You can use sort component to get the sorted output.
--
Siva Sankar Pulivarthi -
Types of .dbc file
What are the two types of .dbc files
madhu922.m
- Dec 21st, 2011
.dbc file is database configuration file. In this file, information to connect the database is given.
Types of files:
1. Fixed length file
2. Delimited fileannegrace1
- Apr 14th, 2009
We don't have diff types of dbc file. We have only one dbc file which is used to connect the component in the GDE with particular database
-
Package editor
What is "Package" and "Package Editor" and how and why it is used.
hari.pardha
- Dec 18th, 2011
Once you log in to transform editor click on view and go to package editor. It is used to have extra tranform abilities like intialise, finalise etc
-
How to get the source from OLTP Systems to the Staging Area in real time
Murali Padala
- Dec 5th, 2011
Continuous flows can be used to enable real time processing in abinitio.
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.
-
What is semi-join
jagan
- Nov 16th, 2011
A semi-join returns rows from one table that would join with another table without performing a complete join. It doesn't have explicit syntax. Eg : semi join to evaluate an exists sub query {gesh...
prabhupurna
- Jul 6th, 2006
in abinitio,there are 3 types of join...1.inner join. 2.outer join and 3.semi join.for inner join 'record...
-
Frequent Compilation Errors
Give 5 most frequently coming compilation errors in your graph?
-
Describe how you would ensure a T-SQL script ran on a particular database where there are multiple databases on a single server.
nayan21
- Oct 31st, 2011
At the start of the script, you can insert below statement to make sure that script will run on a particular database:
use -
Wrapper and .ksh in Ab Initio
Why wrapper scripts are used in job scheduler to run graphs in Ab Initio? Why cannot we use .ksh script in Job scheduler to schedule job?
-
Abinitio Login's Validation
How can we login into the abinitio as a developer?
puneetdking
- Sep 30th, 2011
If u have access to Development server provided by the firm u r working with, then you can log in as developer by giving host name (Dev server name), host type, connection method, your login id and password from Settings > Manage connection menu in abinitio tool
-
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.
-
-
Factless Fact
What is Factless Fact?
-
Ab Initio Dependency analysis
By enabling which parameter, dependency analysis feature get enabled
-
Config Variables in Abinitio
What is the need of config variables in abinitio?(ab_job,ab_max_core) and where to define them?
nagarjuna
- Jul 22nd, 2011
For all ab-initio config variables the command starts with AB_
-
Sort Component
Does sort component read records serial or parellel?
nagarjuna
- Jul 22nd, 2011
It can read both.
chaitugeek
- Sep 17th, 2010
Sort reads?records in a parallel way, because all?groups of records should read and sorted at a time.
Abinitio Interview Questions
Ans