-
-
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.
-
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
-
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?
-
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 -
Frequent Compilation Errors
Give 5 most frequently coming compilation errors in your graph?
-
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...
-
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.
-
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
-
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
-
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 -
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...
-
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...
-
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 ...
-
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!!
-
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...
-
Removing Header and Trailer Records
How to remove Header and Trailer records from a file using abinitio components?
-
-
How to separate duplicate records with out Dedup sorted from the grouped input file?
suren
- Apr 16th, 2012
We can achieve that through the rollup ...
annegrace1
- Apr 8th, 2009
Rollup will help to avoid the duplicate without using dedup component.It takes the first record and reject the rest
-
3 way join component
Hi,
I have 3 files each having 2 cols
e.g
File1
empid deptid
1 100
2 200
3 200
4 100
5 300
File2
empid salary
1 10
2 20
3 30
4 40
Abinitio Interview Questions
Ans