Abinitio FAQs

$ksh -x scriptname graph parameters

Thanks
Srinivas j

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

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

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

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

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

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

edit > parameters or F11

We can achieve that through the rollup ...

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

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

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

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

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

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

You can use sort component to get the sorted output.

--
Siva Sankar Pulivarthi

.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

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

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

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

Vector field is like an array which is used in C/C++.
Its mainly used in normalize and denormalize component.

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