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

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

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

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

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

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

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

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.

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?

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

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

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

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

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

On which parameter based broadcasting partition distribute the records to the outputs?

priti

• Jun 5th, 2012

There is no parameter in broadcast. It simply combines all the records from input ports to a single flow, and copies it to each of its output flow partition

Answer Question  Select Best Answer

arya

• Oct 5th, 2012

Ab Initio Graphical Development Environment
Version 3.1.1 Build ID 427346

Co-Operating System
Version 3.0.5.5

Allen

• Oct 1st, 2012

Ab Initio Graphical Development Environment
Version 3.0.5.3
Build ID 411497

Co>Operating System
Version 3.1.2.6

Answer Question  Select Best Answer

What is the difference between m_mkfs and m_touch.
Both create a MFS how do they differ ?
Also what is the syntax for creating MFS using m_touch

balu

• Oct 6th, 2012

M_mkfs: to create a multifie system
m_touch: to create a empty file system

RAM

• Aug 17th, 2012

M_mkfs will creates a multifile system
M_touch will creates empty multifile

Answer Question  Select Best Answer

Hi Guys,

I have a requirement :

We need to design a graph for transition of some files. The details like filename, parameter_id (unique) we need to get from a table in DB and these should be included in the graph pset one at a time. That means for every unique parameter_id graph should run once.

Like we can have the parameter_id as the Job_name for the graph.

Satish

• Oct 8th, 2012

I am really not sure why you will have to create a dynamic PSet. That parameter file is for the static values but not the dynamic values. If you have some value witch is stored in the system and if yo...

Siva

• Jul 11th, 2012

You can use the air commands to create PSET for graph and add parameters to PSET. These commands can be executed in the wrapper scripts inside the while loop.

example/syntax:

air sandbox pset graph1.pset -protoype $PROJECT_DIR/mp/mygraph.mp

air sandbox parameter -path

Answer Question  Select Best Answer

my requirement

header contains - business date
details contains - reccords
trailler contains - total no of records in detail.
1) header , detail , trailer separation with indicator filed ( conditional dml with indicator field )
2)Comparing header with business date , if not match fail. ( using lookup with date function)
3)comparing the record count of...

raju

• Oct 9th, 2012

Input dataset---->dedup sort------> output file

In dedup sort component next_in_sequence > 1 then keep parameter make it as last. output port getting the trailer record, dedup port getting the detail records (if header, detail and trailer are in sequence)

Rushieksh Deshapnde

• Aug 30th, 2011

In Reformat have output index separate header,trailer and data based on it in transform 0 write xfr for matching business date using lookup expression for that use

Answer Question  Select Best Answer

shan

• Oct 11th, 2012

Sandbox Level Parameters

Sachin

• Apr 26th, 2012

$AI parameters are sandbox level parameters like $AI_XFR, $AI_XML

Answer Question  Select Best Answer