Explain the deployment of graph, with start and end script?

kalrac

 Profile Answers by kalrac Questions by kalrac

• Jul 19th, 2010

Thanks for the response,My actual question is when there is a start script and end script. When the execution starts from start script > graph>end script. But the deployed ksh in unix is not of ...

abmaahi

 Profile Answers by abmaahi Questions by abmaahi

• Jul 19th, 2010

Basically when we execute the graph first start script are executed before graph and later end scritpt is executed in the GDE.

Answer Question  Select Best Answer

Munmun

• Mar 31st, 2015

Air sandbox have many options. Each are having different use.

Such as air sandbox run will run graph pset plan

air sandbox show-common will show the included common sandboxes.

shan88

• Dec 21st, 2012

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

Answer Question  Select Best Answer

seemabuchhada

 Profile Answers by seemabuchhada Questions by seemabuchhada

• Mar 15th, 2014

In most cases you are unloading enough data to require a parallel unload. Adding the ABLOCAL(tablename) clause to your SQL statement prevents the Input Table component from parsing the SQL and specifi...

sham2sushil

 Profile Answers by sham2sushil Questions by sham2sushil

• Oct 27th, 2010

The use of ABLOCAL() construct is in Some complex SQL statements contain grammar that is not recognized by the Ab Initio parser. When data is unloading in parallel.  Then ABLOCAL() construct ...

Answer Question  Select Best Answer

What is .pset?

nagarjuna

• Jul 22nd, 2011

.pset is a input parameter file.

arunfrank1

 Profile Answers by arunfrank1 Questions by arunfrank1

• Jun 6th, 2011

Above version 1.15 the inputs which we pass as graph parameters are stored in a file called pset.Its stored in folder pset.Generally pset file will be save as same as graph name with extension .pset--Anne

Answer Question  Select Best Answer

Give 5 most frequently coming compilation errors in your graph?

sudharsan

• Nov 2nd, 2011

Reject record should be the runtime error.

Ashutosh Prasad

• Sep 29th, 2011

Can be many. Some are:

File/Source cannot be read.
Data out of order.
Metadata mismatch.
Reject Record.
etc...

Answer Question  Select Best Answer

What is the optimistic partitioning component in abinitio? How can we say that it is an optimistic partition component?

dulamuday

 Profile Answers by dulamuday Questions by dulamuday

• Dec 9th, 2010

Partition by Round Robin is Optimistic Component, by using data skew we can say that it is optimistic component

Six face

 Profile Answers by Six face Questions by Six face

• Nov 29th, 2010

Round Robin is the optimistic partition.

Answer Question  Select Best Answer

By enabling which parameter, dependency analysis feature get enabled

rakesh

• Aug 17th, 2011

Changes to the above answer ..... In the GDE choose File > Preferences to open the Preferences dialog. Click the Advanced tab, select the Documentation Transforms checkbox and click OK. To set th...

Rakesh

• Aug 17th, 2011

On the GDE menu bar, select File > Preferences.

In the Parameters group of the GDE Preferences dialog, select Document Function.

Open the Properties dialog; in parameter Document Function should be visible.

Answer Question  Select Best Answer

How can we do metadata level programming in dml itself to remove blank lines from a file

Shrikant Salunke

• Aug 27th, 2016

Sed with -i option makes changes in the file directly.

sed -i /^$/d dml_filename

aditya

• Oct 3rd, 2012

You can use unix command
sed /^$/d dml_filename > new_filename

Thanks
Aditya

Answer Question  Select Best Answer

raja

• Feb 9th, 2015

You can keep the reformat reject threshold as never abort or
if you know for which column it is coming invalid ,we can use is_valid function and provide some default values

Harpreet Singh

• Jul 1st, 2013

Set the reject threshold to "Never Abort" and capture all data rejects in a file

Answer Question  Select Best Answer

With open a graph how should we know how many input files are using in that graph?

Rahul

• Apr 7th, 2015

Hi Puneet its asking for object relative path...Could you please elaborate a little bit.

puneetdking

 Profile Answers by puneetdking Questions by puneetdking

• Sep 30th, 2011

there is one air command that can help you - air project get-required-file == This command finds and displays the files in a project that the specified object(s) depends on. This command is branch-sp...

Answer Question  Select Best Answer

Instead of m_ filename if we do a rm filename by mistake and want to recover that control file, how do we do it? can it be done using a checkpoint, if yes how and is there another way?

Siva Parvathi

• Jun 5th, 2017

If only control file got deleted, simply it can be created using m_touch
As data remains in partitions, it automatically can point to corresponding partitions

Tanz

• Mar 21st, 2012

If data files are present simply do m_touch control file name

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

I have a master file with user personal details and around 50k users.
Each day a transaction file with about 100million records come in and we need to update transaction file with user details present in master file.

What is a good approach for this?

kalyanvadlamudi2kn

 Profile Answers by kalyanvadlamudi2kn Questions by kalyanvadlamudi2kn

• Jan 8th, 2014

1)I partition the data first 2)Remove unwanted fields if applicable 3)Followed by sorting on the matching key in first data if it can fit in memory without data spill as it small and other i wil...

sriram

• Dec 11th, 2013

Join with old master and new master file. you will get matched record those are not going to update. unused records are new records ,which are loaded into table.

Answer Question  Select Best Answer

I have a serial graph with below sequence:
i/p -> sort(key1)->rollup(key1)->sort(key2)->rollup(key2)->normalise->o/p.

How do we improvise this graph?

gouse

• Nov 20th, 2015

By reducing number of sort components

raja

• Feb 10th, 2015

It depends on your input data.If you specify some of your input data will be more helpful. My suggestion is instead of using two roll up and two sort keys try to use it only one rollup with key1 and key2

Answer Question  Select Best Answer

Hi I have a few questions in AbInitio. It would be very useful, if some one answered.
1.How to bring souce files(Flat files) to Unix environment?
2.How to go to GDE from Unix after connected to Unix Host?
3. How to integrate o/p folder / file to target database (SQL Server)?
4.Is staging area required in AbInitio? If yes, when is that?

Please answer these ques.

Sid

• Dec 10th, 2014

1. If the requirement is to just move the files to Unix , you can do that using WINSCP tool
2. Depends on where you install GDE , in unix or windows ?
3. You can map the data after transforming (if required) to a target table.
4. Staging is not mandatory

kishore

• Nov 10th, 2014

GDE is one of the component in Abinitio tool

Answer Question  Select Best Answer

Could you please explain me in details differences between Multi File s and Adhoc Files ?

Thanks in Advance.

gouse chpet

• Jul 15th, 2015

Collection of individual files is known as multifiles.
m_mkfs < control partition >< data partition >......

Collection of individual files having same dml is known as adhoc multi files.

anuvardhan

• May 18th, 2015

Collection of files is known as multifile.
collection of files having same dml function is known Adoc multifile

Answer Question  Select Best Answer

If I am having two table- customer and transaction. I am having 100 rows and 10 columns and I want to perform the join with NULL key, then how much output records I will get?

nagesh

• Aug 17th, 2017

Cartesian product :100*10= 1000 records

Kiran

• May 8th, 2015

If you are passing null key to Join component , you will get Cartesian product (input1 records X input2 records).
Thanks in Advance.

Answer Question  Select Best Answer

If you have one input file it have some thousands of records then how to Seperating the header and trailor records from the input file?

gouse

• Nov 1st, 2015

Record identifier with reformat or deduo sort or filter by expression.

Sagar Sali

• May 14th, 2015

1) If the header and trailor is denoted by some special separator like H or T, you can use filter by expression and condition like (rec_type != "H" and rec_type != T")

2) You can use 2 dedup component and in first comp, keep first and next use comp, keep last, so u can separate.

Answer Question  Select Best Answer

a) Using a rollup,how many records will you get?
b) How can I get more than 100 records?
c) How can I get 1 record?

Bibhu Prasad Behera

• May 30th, 2015

A. Using Rollup ,you can get 100 or less than 100 records.(depending upon the key )
b.Use normalize to get more than 100 records.
c.Use Rollup with null key.

tanay

• May 24th, 2015

Using roll up on null key can give you one record.

Answer Question  Select Best Answer

I have 10 million records in one file, if I develop a graph with this file, it takes more time to be executed, but I want to decrease the execution time. How can you proceed?

Jerry

• Jun 26th, 2015

You may use the following performance improvement techniques depending on the situation: 1. You may convert the serial file to multifile system using a partition by key, if it is a serial file. 2. Y...

Rajesh Matcha

• Jun 10th, 2015

You have not mentioned that whether your graph is a serial graph or a parallel graph , If it is serial make it parallel as soon as possible , if you are doing some specific business rules ..filter th...

Answer Question  Select Best Answer