GeekInterview.com
Series: Subject:

Abinitio FAQs

Showing Questions 1 - 20 of 70 Questions
First | Prev | | Next | Last Page
Sort by: 
 | 

What is .Rec file and .Job file?

Asked By: venky84 | Asked On: May 7th, 2013

Hi if want to run the graph in UNIX !What command I need to use ?Correct me if im wrong :-run

Asked By: sekhu_da | Asked On: Nov 15th, 2006

Answered by: jsrinivas.bt on: Apr 27th, 2013

$ksh -x scriptname graph parameters

Thanks
Srinivas j

Answered by: aditya_kundu on: Sep 18th, 2010

You can deploy the graph and generate the .ksh file which you can directly execute or use the following command to execute the graph:
air sandbox run .mp

3 way join with different column names.

Asked By: vital_parlsey | Asked On: Mar 1st, 2012

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 5 ...

Answered by: PLMS on: Mar 29th, 2013

Step 1: File1 - left outer Join {Key- empid} with -File2 Step 2: The above output flow should be sort{PBKS-if multifile} based on key empid Step 3: The step 2s o/p flow to be left outer joi...

Answered by: Malini on: Apr 3rd, 2012

Code
  1.   SELECT C.DEPTNAME,sum(B.SALARY) FROM FILE1 A ,FILE2 B ,FILE3 C
  2.   WHERE A.EMPLID=B.EMPLID AND A.DEPTID=C.DEPTID
  3.   GROUP BY C.DEPTNAME

Abinitio developer role

Asked By: shan88 | Asked On: Oct 25th, 2012

What is a framework in abinitio all about? Can anybody explain me in detail about what an abinitio developer in general does in his job?

Answered by: PLMS on: Mar 29th, 2013

The expected roles of abinitio developer has been below: i) Know how to work in Abinitio products GDE,EME,Co>Op & good exposure to unix scripting to create wrapper scripts & execute basic commands. ii...

What is air sandbox in ab initio?

Asked By: Geek2002 | Asked On: Aug 30th, 2010

Answered by: shan88 on: Dec 21st, 2012

Air sandbox commands are used to run a graph,pset from the Unix

Abinitio

Asked By: harik5366 | Asked On: Sep 29th, 2012

How to write the script in abinitio by using UNIX?

Answered by: Alok Sahoo on: Nov 15th, 2012

You can create a script in UNIX in the general way like you are writing a shell script.

Graph parameters

Asked By: surendra.pgt | Asked On: Aug 12th, 2010

How can you set the parameters to call the graphs?

Answered by: shan88 on: Oct 17th, 2012

edit > parameters or F11

How to separate duplicate records with out dedup sorted from the grouped input file?

Asked By: anji_abinitio | Asked On: Nov 24th, 2007

Answered by: suren on: Apr 16th, 2012

We can achieve that through the rollup ...

Answered by: annegrace1 on: Apr 8th, 2009

Rollup will help to avoid the duplicate without using dedup component.
It takes the first record and reject the rest

Removing header and trailer records

Asked By: chaitugeek | Asked On: Sep 15th, 2010

How to remove header and trailer records from a file using abinitio components?

Answered by: arnab ghosh on: Feb 22nd, 2012

Use Unix SED #--------------------------------------------------------------# # This line removes both the header and the trailer record #----------------------------------------------------------...

Answered by: nagarjuna on: Jul 21st, 2011

You cam redefine format, Filter by expression & Run program components.

Abinitio dml usage in Informatica source creation

Asked By: niharika88 | Asked On: Feb 23rd, 2012

Can we create an Informatica source by using the dml of the corresponding abinitio source,by importing the dml,without using the manual create source option?

What is a control file in abinitio?

Asked By: shaik.inayathulla | Asked On: Jan 11th, 2012

Answered by: siva sankar pulivarthi on: Feb 8th, 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...

Which file should we keep it as a look up file, large file or less data records file & why?

Asked By: vamshi | Asked On: Apr 29th, 2007

Answered by: Ram on: 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...

Answered by: siva sankar pulivarthi on: Dec 27th, 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

Asked By: vijayp57 | Asked On: Nov 14th, 2010

How to get sort data in i/p by using single component in abinitio?

Answered by: siva sankar pulivarthi on: Dec 27th, 2011

You can use sort component to get the sorted output.

--
Siva Sankar Pulivarthi

Types of .Dbc file

Asked By: surabhiraghu | Asked On: Dec 31st, 2007

What are the two types of .Dbc files

Answered by: madhu922.m on: 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 file

Answered by: annegrace1 on: 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

Asked By: GulsArs | Asked On: Mar 19th, 2010

What is "package" and "package editor" and how and why it is used.

Answered by: hari.pardha on: 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

Wrapper and .Ksh in ab initio

Asked By: abinito | Asked On: Apr 30th, 2010

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?

Answered by: chekri on: Oct 6th, 2011

wrapper Script executes multiple graphs(or) jobs,that means multiple .ksh jobs are going to execute here,
where coming to .ksh which will be execute a single component process. that means every component process having the .ksh process

What is vector field? Explain.

Asked By: swapnamsundari | Asked On: May 5th, 2007

Answered by: arpit mathur on: 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

Answered by: annegrace1 on: 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

Asked By: Geek2002 | Asked On: Aug 30th, 2010

What is factless fact?

Answered by: sree on: Aug 19th, 2011

The fact which is not having any measures(like Quantity) are called factless fact

First | Prev | | Next | Last Page

 

 

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Ads

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.