anil

• May 21st, 2012

Hi,In abinitio we can create mfs with this command press F8 write the m_mkfs pathnamefilename

vijay_kramarao

 Profile Answers by vijay_kramarao Questions by vijay_kramarao

• Oct 30th, 2006

Syntax: m_mkfs <name of the control partion> <URL of the first partion> <URL of the second partion> <URL of the third partion>....... Eg: m_mkfs controlpartion c:abin...

Answer Question  Select Best Answer

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

chandrasekhar

• May 10th, 2012

1.Perform inner join for both file1 & file2
2.perform sort on dept id then do Roll up
3.perform inner join for roll up o/p and file3
4.finally you will get required result

Answer Question  Select Best Answer

suren

• Apr 16th, 2012

We can achieve that through the rollup ...

annegrace1

 Profile Answers by annegrace1 Questions by annegrace1

• Apr 8th, 2009

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

Answer Question  Select Best Answer

How do you find the size of MFS file?

Vinoth raj

• Mar 29th, 2012

Use m_ls -ltr file name you will have the record count and also size of it.

PN Reddy

• Feb 9th, 2012

Using m_expand you can know the count of partition on the file

Answer Question  Select Best Answer

How to remove Header and Trailer records from a file using abinitio components?

arnab ghosh

• Feb 22nd, 2012

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

nagarjuna

• Jul 22nd, 2011

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

Answer Question  Select Best Answer

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?

Hi,
Can we create an informatica source by using the the abinitio dml directly rather than manually creating the source.Just like the way,I tried for creating an informatica source from an informatica target by making respective changes in the xml structure and importing the same.

siva sankar pulivarthi

 Profile Answers by siva sankar pulivarthi Questions by 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...

Answer Question  Select Best Answer

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

 Profile Answers by AsheshN Questions by 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!!

Answer Question  Select Best Answer

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

 Profile Answers by vijayv Questions by 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 you

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

Answer Question  Select Best Answer

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

 Profile Answers by tanuj_06 Questions by tanuj_06

• Jul 9th, 2011

There is something called Conduct IT...Plans where u can schedule multiple graphs in abinitio...

Answer Question  Select Best Answer

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

 Profile Answers by siva sankar pulivarthi Questions by 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...

Answer Question  Select Best Answer

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

siva sankar pulivarthi

 Profile Answers by siva sankar pulivarthi Questions by siva sankar pulivarthi

• Dec 28th, 2011

You can use sort component to get the sorted output.

--
Siva Sankar Pulivarthi

Answer Question  Select Best Answer

What are the two types of .dbc files

madhu922.m

 Profile Answers by madhu922.m Questions by 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 file

annegrace1

 Profile Answers by annegrace1 Questions by annegrace1

• 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

Answer Question  Select Best Answer

What is "Package" and "Package Editor" and how and why it is used.

hari.pardha

 Profile Answers by hari.pardha Questions by 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

Answer Question  Select Best Answer

Murali Padala

• Dec 5th, 2011

Continuous flows can be used to enable real time processing in abinitio.

vikki_gupta2003

 Profile Answers by vikki_gupta2003 Questions by 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.

Answer Question  Select Best Answer

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

 Profile Answers by prabhupurna Questions by 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...

Answer Question  Select Best Answer

Give 5 most frequently coming compilation errors in your graph?

sudharsan

• Nov 2nd, 2011

Reject record should be the runtime error.

Ashutosh Prasad

• Sep 29th, 2011

Can be many. Some are:

File/Source cannot be read.
Data out of order.
Metadata mismatch.
Reject Record.
etc...

Answer Question  Select Best Answer

nayan21

 Profile Answers by nayan21 Questions by 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

Answer Question  Select Best Answer

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?

chekri

• 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

Answer Question  Select Best Answer