Ab Initio

Do you mean by merging Gui map files in WR.If so, by merging GUI map files in GUI map editor it wont create corresponding test script.without testscript you cant run a file.So it is impossible to run a file by merging 2 GUI map files.

Explain plan can be reviewed to check the execution plan of the query. This would guide if the expected indexes are used or not.

Take an entire database backup and restore it in different instance.

Take a statistics of all valid and invalid objects and match.

Periodically refresh

Because every job depend upon another job for example if you first job result is successfull then another job will execute otherwise your job doesn't work.

By using rollup we cant generate cumulative summary records for that we will be using scan.

Basically,This is a part of D.B.A responsibilities GRANT means permissions for example GRANT CREATE TABLE ,CREATE VIEW AND MANY MORE .

REVOKE means cancel the grant (permissions).So,Grant or Revoke both commands depend upon D.B.A.

Because implicit is using for internal processing and explicit is using for user open data requied.

Dependency analysis will answer the questions regarding datalinage.That is where does the data come from,what applications prodeuce and depend on this data etc.

We can retrieve the maximum (surrogate key) from the existing data,the by using scan or next_in_sequence/reformat we can generate further sequence for new records.

Two are graph level parameters but in local you need to initialize the value at the time of declaration where as globle no need to initialize the data it will promt at the time of running the graph for that parameter.

In RUN ==> Deploy >> As script , it create a .bat file at ur host directory ,and then run .bat file from Command prompt

1.10 is a non key version and rest are key versions.

There are lot of components added and revised at following versions.

Here is a simple example to use a start script in a graph:

In start script lets give as:

export $DT=`date '+%m%d%y'`

Now this variable DT will have today's date before the graph is run.

Now somewhere in the graph transform we can use this variable as;

out.process_dt::$DT;

which provides the value from the shell.

The genaral syntax is "m_dump metadata data [action] "

Batch Processing is nothing but , not delaing with Transcalational data

If your source is a cobol copybook, then we have a command in unix which generates the required in Ab Initio. here it is:

cobol-to-dml.

Maxcore is a value (it will be in Kb).Whne ever a component is executed it will take that much memeory we specified for execution

The main difference b/w dml & xfr is that

DML represent format of the metadata.

XFR represent the tranform functions.which will contain business

rules

skew is the mesaureof data flow to each partation .

suppose i/p is comming from 4 files and size is 1 gb

1 gb= ( 100mb+200mb+300mb+5oomb)

1000mb/4= 250 mb

(100- 250 )/500= --> -150/500 == cal ur self it wil come in -ve value.

calclu for 200,500,300.

+ve value of skew is allways desriable.

skew is a indericet measure of graph.

ChalapathiFirst we can check the properties in internet options and then u can check in cmd format telenet abinitio ip_add.