Suppose I have a project having many xfrs, I cannot check manually to understand the complexity of a xfr or graph, How can I check it, any command?
Can we understand its complexity just by checking dependency of a graph or XFR?

Sandeep

• Mar 25th, 2018

Air project analyze-dependencies relative_path -complexity
air project analyze-dependencies relative_path -complexity-details
air sandbox validate-graph path -complexity
air sandbox validate-graph path -complexity-details

Answer Question  Select Best Answer

There is a SFTP component placed at last of the graph.
Lineage report keeps on failing for every run because, the destination server cannot be considered.
It was success for all other components/subgraps in that graph.

Could you please help me here how can I get lineage report success?

anthati

• Oct 25th, 2018

Use document component to set graph lineage

Answer Question  Select Best Answer

How to generate DML from backend and front end?

inamdnik

 Profile Answers by inamdnik Questions by inamdnik

• Jul 3rd, 2018

Did you mean generate DML from UNIX(Back-end) and GDE(Front-end)?
If so then below is the answer
1. Generating DML from UNIX level
m_db gendml -table > $AI_DML/

2. Generating DML from Graph(GDE) level
You can create it from any components port tab--> Same As and Embedded radio buttons.

Answer Question  Select Best Answer

What is the main difference between max core and max memory.
Where we use this commonly?

Rahul Rasal

• Jan 25th, 2019

Max core : component max-core parameter determines the maximum amount of memory the component will consume per partition before it spills to disk.
max memory : Enables the collection of memory usage data for components.

Answer Question  Select Best Answer

I have an XML file with all the details of an employee. I just want to mask the firstname and lastname records as AAAA and generate the XML with all other fields including firstname and lastname. Please suggest on this

Ajanth

• Feb 19th, 2020

Read xml-->reformat (concat(masked chars+substr(name))-->write xml

Answer Question  Select Best Answer

siddharth ranga

• Sep 29th, 2005

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

Answer Question  Select Best Answer

pardip sidhu

 Profile Answers by pardip sidhu Questions by pardip sidhu

• Oct 26th, 2005

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

Answer Question  Select Best Answer

pardip sidhu

 Profile Answers by pardip sidhu Questions by pardip sidhu

• Oct 26th, 2005

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.

Answer Question  Select Best Answer

siddharth ranga

• Sep 29th, 2005

There are several ways to do this:1) We can move the table in the same or other tablespace and rebuild all the indexes on the table.alter table <table_name> move <tablespace_name> this act...

Answer Question  Select Best Answer

veerapratap reddy

• Oct 12th, 2006

   WE can use backup the EME with air-repostory backup command from the command line mode.

Answer Question  Select Best Answer

kalyan

• Jun 20th, 2006

There are quite a few factors that determines the approach such as what type of version control are used, what is the size of the change, what is the impact of the change, is it a new procedure or rep...

Answer Question  Select Best Answer

kalyan

• Jun 20th, 2006

Take an entire database backup and restore it in different instance. Take a statistics of all valid and invalid objects and match.Periodically refresh

Answer Question  Select Best Answer

how to create a wrapper script in Ab Initio?

Nagesh

• Jul 18th, 2011

Wrapper scripts are used to run the graphs though command prompt
ex
abc.sh
within the abc.sh, we define the graphs ksh like
$/xyz.ksh -param1 -param2.....

then we use the wrapper script(abc.sh) to run the graph from command prompt(unix) using
./abc.sh

i hope this will help you.

Answer Question  Select Best Answer

Ashim Dutta

• Oct 25th, 2005

Double click on the transform parameter of parameter tab page of component properties, it will open transform editor. In the transform editor click on the Edit menu and then select Add Default Rules from the dropdown. It will show two options - 1) Match Names 2) Wildcard.

Answer Question  Select Best Answer

Ashim Dutta

• Oct 20th, 2005

Basically there are serial and parallel layouts supported by AbInitio. A graph can have both at the same time. The parallel one depends on the degree of data parallelism. If the multi-file system is 4...

Answer Question  Select Best Answer

ramesh

• Dec 14th, 2005

To unload (retrive)  Data from the database DB2, Informix, or Oracle we have components like Input Table and Unload DB Table by using these two components we can unload data from the database

Answer Question  Select Best Answer

Shashidhar

• Jan 25th, 2006

Contineous components used to create graphs,that produce useful output file while running continouslyEx:- Contineous rollup,Contineous update,batch subscribe

Answer Question  Select Best Answer

K Nagi Reddy

• Feb 10th, 2006

Fixed length DML's are faster because it will directly read the data of that length without any comparisons but in delimited one,s every character is to be compared and hence delays

Answer Question  Select Best Answer

Shaza

• May 18th, 2006

try "m_db test myfile.dbc"

Answer Question  Select Best Answer

satya koganti

• May 9th, 2006

Hi ChalapathiFirst we can check the properties in internet options and then u can check in cmd format telenet abinitio ip_add .i think it will help u .Cheers..........Koganti

Answer Question  Select Best Answer