Segregate the header, trailer & body by either using part 
by expression component or using filter by exp. Use 
next_in_sequence() function to a new column of the data 
record. Use sort on descending to sort the data on the 
next_in_sequence() column.

RUN SQL COMPONENT

exec proc-name (parameters)
exec proc-name ('$DATE')
exec proc-name ('20080101')

Whenever we sort a set of records with NULL key 
automatically it consider the records as one group & data 
will be as per the input serial number and will be sorted 
according to that.But dedup will again cosider the records 
as one group &  output will be the first record 
automatically.
e.g.input records:1,XYZ,100;
                  2,ABC,700;
                  5,JJJ,400;
                  7,KKK,500;
 using NULL key sort component will give output as:
                  1,XYZ,100;
                  2,ABC,700;
                  5,JJJ,400;
                  7,KKK,500;
Dedup sort will give output as:
                  1,XYZ,100;

i think in the above case dedup sort will give all the
records in out put even if we sort on any of the three 
fields

Your result will come as per you specify the first/last
record. as it does not sort the records.

ex:
Input  
A   B   C
----------
1   a    d
4   f    h
6   y    g
7   g    u
2   i    o

Output
a: if selected first record in dedup
A   B   C
----------
1   a    d

b: if selected last record in dedup
A   B   C
----------
2   i    o

headers and trailers are processed like this only.

Yes the graph will run. Only the records in the partition 
being deleted won't be processed.

Repartitioning Technique in Ab Initio is to apply 
departition on a data set and the apply Partitioning on the 
transformed data.
Its used when there is requirement of changing 2way mfs 
into 4way.
I dont know any otherways of achieving this Repartitioning.

Thanks

Hi 

I dont know how to attach pdf's in here, I can send it to 
your personal id if you send me your id, mine is 
d_deep12@yahoo.com

please provide
pdfs or material or books on Abinitio

I also need the materials .

Run the .ksh script generated by the GDE

a graph can be run by getting the script for the graph from 
the abinito interface and then running it using shell 
scripting

air sandbox run <name-of-graph>
air sandbox run <name-of-graph-pset>

if u have to extract data from a database system (A) which 
is on server(B). for connecting to server(B) provide the 
username, encrypted password, connection method, 
servername, etc in ur .abinitiorc file and provide all the 
database(B) detail in ur .dbc file of ur component used for 
doing extraction (input table component).

generally you will find development, QA and production 
phase. If all these 3 phases are there then in development 
phase u will never use actual data, but before moving the 
graph to prodution it needs to pass through QA where you 
have to test against the actual data.

Here are the few of the commands we use 


1) air object ls <EME Path for the object -
 /Projects/edf/.. > --- This is used to see the listing of 
objects in a directory inside the project. 

2) air object rm <EME Path for the object -
 /Projects/edf/.. > -- This is used to remove an object 
from the repository. Please be careful with this. 

3) air object cat <EME Path for the object -
 /Projects/edf/.. > --- This is used to see the object 
which is present in the EME. 

4) air object versions -verbose <EME Path for the object -
 /Projects/edf/.. > --- Gives the Version History of the 
object. 

5) air project show <EME Path for the project -
 /Projects/edf/.. > --- Gives the whole info about the 
project. What all types of files can be checked-in etc. 

6) air project modify <EME Path for the project -
 /Projects/edf/.. > -extension <something like *.dat within 
single quotes> <content-type> --- This is to modify the 
project settings. Ex: If you need to checkin *.java files 
into the EME, you may need to add the extension first. 

7) air lock show -project <EME Path for the project -
 /Projects/edf/.. > --- shows all the files that are locked 
in the given project 

8) air lock show -user <UNIX User ID> -- shows all the 
files locked by a user in various projects. 

9) air sandbox status <file name with the relative path> ---
 shows the status of file in the sandbox with respect to 
the EME (Current, Stale, Modified are few statuses)

.db consists info   used by gde to connect to database 
.cfg consists info   used by co>op to connect to database

.cfg - > Database table configuration files for use with 
2.1 Database components

.dbc -> Database configuration files

Both .dbc and.cfg files are database configuration files.

The .cfg files are older version of database configuration 
files used with 2.1 database components.

db config gives details about the database configeration 
whereas cfg gives gives the entire configeration details

wc

throw co>op

connect as dba to the database and fire the query
show db_parameter_file; on oracle database (I am not sure 
on query, u can search for a similar query)