nmalik50

 Profile Answers by nmalik50 Questions by nmalik50

• Jul 7th, 2009

The name of the SQL language is TSQL

MadhuriKumar

 Profile Answers by MadhuriKumar Questions by MadhuriKumar

• Apr 24th, 2008

SQL stands for Structured Query Language.

Answer Question  Select Best Answer

basuatrayee

 Profile Answers by basuatrayee Questions by basuatrayee

• Jan 30th, 2008

There can be numerous sandboxes for a project but there should be only one sandbox associated with EME for a project.

surabhiraghu

 Profile Answers by surabhiraghu Questions by surabhiraghu

• Dec 31st, 2007

We can have any no of sandboxes, sand box is nothing but users work area where each user  will get copy of the project & do the modifications acc.

Answer Question  Select Best Answer

chandan

• Feb 7th, 2007

In SW world fencing means job controlling on priority basis. In AI it actually refers to customized phase breaking. A well fenced graph means no matter what is source data volume process will not cough in dead locks. It actually limits the number of simultaneous processes.

Rajeev M Sankarathil

• Dec 6th, 2006

I think he is refering to "Phasing" only.Phasing:- Its a way to manage the resource and avoid "deadlocks" in the Abi run. it limits the number of simultaneous processes by breaking up the graph into different phases, only one of which is running at any given time.

Answer Question  Select Best Answer

mukund

• Dec 15th, 2006

yeah,  abinitio is a combination if GDE(graphical development environment),co^operating system,and EME(enterprise metadata environment)each have its own importance and are inter-related.generally...

sekhu_da

 Profile Answers by sekhu_da Questions by sekhu_da

• Nov 14th, 2006

abintio is like blub ! co-op is like current(transformer) ..bulb will glow only when current is passsed ..

Answer Question  Select Best Answer

amitesh87

 Profile Answers by amitesh87 Questions by amitesh87

• Apr 2nd, 2009

From UNIX you can go to pset folder in your sandbox then type??air sandbox run abc.pset Whatever may be your psets name or just call graph script .ksh

mahendra patnaik

• Feb 5th, 2007

Hi,it is possible in Unix... first you have to go to the directory where your deployed script is saved for that particular graph then execute the shell script by using the following command.../.kshI hope it will help you ...regards,Mahendra

Answer Question  Select Best Answer

abmaahi

 Profile Answers by abmaahi Questions by abmaahi

• Jun 12th, 2010

API mode is for more diagnostic purpose for retriving the data from db means like selecting perticular fields, like retriving the data relatively according to the constraints.  Whenever we select...

subhajitpalit

 Profile Answers by subhajitpalit Questions by subhajitpalit

• Dec 11th, 2009

In API mode the data processing(load/update/insert/delete) is slow, however other process can access the database tables during the update.Compared to above, Utility mode processing(load/update/insert...

Answer Question  Select Best Answer

mahendra patnaik

• Feb 5th, 2007

Hi,EME contains only the latest version graphs of your project. It is a area where single or multiple projects will stored. for checkin or check out the graph into the EME you have to look on to the...

sekhu

• Dec 22nd, 2006

sandbox --> is the personal work area and u will find only latest vesrons of the graphs.eme is like vss ! there u will find old and new versions of the graphs.when u check in / out the graph that will come into your sandbox area.hope this will help you..

Answer Question  Select Best Answer

HI,I've installed GDE 2.8 on windows Xp,and our database running as oracle9i,how do we install co-operating system... and on the same machine informatica server& client also running.does it matter of informatica software exists where abinitio gonna installed...pls do let me know the steps of installation process of Abinitio.Thanks,SindhuReddy

Suresh

• Feb 27th, 2017

Hi Vasu, I would like to use Ab initio in local machine. My OS is Windows 10. I am trying to install Abinitio co operating system environment using comparability mode, but not able to install as it is showing "Needs Windows NT 4.0"

gopal

• Jan 24th, 2007

Hi vasuInstalled in XP professional Abinito 2.10 co>op sys and 1.10.8 GDE version.I created dml and data in serial file.--dml is simpleas well as graph with FBE & out filei want to see data from file ...

Answer Question  Select Best Answer

saikumar

• Jun 29th, 2022

Multistage componets means transform components rollup,reformat,and scan normalize

Anjali

• Nov 19th, 2021

Multistage transform is a transform that modifies in up to five-stage - input selection, temporary initialization, processing, finalization and output selection
multistage transform components are -
rollup
scan
scan with rollup
normalize
denormalize sorted

Answer Question  Select Best Answer

Mathi777

 Profile Answers by Mathi777 Questions by Mathi777

• Jul 3rd, 2008

When ever a graph fails it creates a .rec file in the working directory ,the directory may be where ur graph deployed script is stored .so remove that .rec file an dthen run the deployed script of the graph from unix,u may use m_rollback -d

sixto.dsilva

 Profile Answers by sixto.dsilva Questions by sixto.dsilva

• Jun 25th, 2008

You can run the graph by giving the following command in unix dtm run <recvory file name> -continue

Answer Question  Select Best Answer

How do we merge graphs in AbInitio?

abhi_fresh_as_dew

 Profile Answers by abhi_fresh_as_dew Questions by abhi_fresh_as_dew

• Dec 11th, 2008

Get on using .plan in Abinitio in which we can encapsulate different graphs.Abhisek Bfresh as dew!!

Sabitra S Panda

 Profile Answers by Sabitra S Panda Questions by Sabitra S Panda

• Dec 10th, 2008

Any graph in ab initio is a separate and independent entity in itself. First of all, there is no such concept of graph merging in ab initio, since it does not make any sense, and two graphs that are s...

Answer Question  Select Best Answer

Can we process 1 GB data(1 million records) by using Lookup? How

abhi_fresh_as_dew

 Profile Answers by abhi_fresh_as_dew Questions by abhi_fresh_as_dew

• Feb 3rd, 2010

Processing 1GB data with a small lookup file is good ... but to make the 1GB data as a lookup file is mistake.Use mfs lookups instead if its at most needed.

anujaja

 Profile Answers by anujaja Questions by anujaja

• Aug 25th, 2009

I will suggest you to use Join instead of Lookup for such voluminous data

Answer Question  Select Best Answer

How do change serial file into MFS? Explain

abmaahi

 Profile Answers by abmaahi Questions by abmaahi

• Mar 29th, 2010

Go to run command or press F8You will get the one text box in that type m_mkfs [path0] [path1]..This is for cration of multifile system after that create one file in that path by using m_touch [path0]...

njvijay

 Profile Answers by njvijay Questions by njvijay

• May 11th, 2008

1. Make sure you have multifile system in your ab-initio environment2. Then use partition component to distribute your records to MF

Answer Question  Select Best Answer

In production also do they will give same password which was given in .DBC?

sixto.dsilva

 Profile Answers by sixto.dsilva Questions by sixto.dsilva

• Jul 3rd, 2008

Best way is using the environment variable  to set the values in dbc file. By this you can have the flexibility to change any variable value's by changing the evironment variable.

njvijay

 Profile Answers by njvijay Questions by njvijay

• May 11th, 2008

Good way doing this is, parameterize .dbc file. Parameter will have different values for different environment.

Answer Question  Select Best Answer

There is one MF while loading data i deleted one partition in a MF? Can it show error/it will process data?

sixto.dsilva

 Profile Answers by sixto.dsilva Questions by sixto.dsilva

• Jul 25th, 2009

yes the above point is also valid , if file does not exist , the ab initio will throw an error. If it is truncated ,you will loose the data but abinitio will not throw an error.

njvijay

 Profile Answers by njvijay Questions by njvijay

• May 11th, 2008

Did you delete data in partition or deleted partition itself?If data is deleted (or truncated) in a partition, ab-initio does not throw the error.If a partition itself is deleted, ab-initio is going to throw the error.

Answer Question  Select Best Answer

sixto.dsilva

 Profile Answers by sixto.dsilva Questions by sixto.dsilva

• Jun 22nd, 2009

I think i misunderstood the question ,there are 3 type of parallelisms in Ab Initio , details of 3 types are expalined correctly above with difference.

ravula sudheer

 Profile Answers by ravula sudheer Questions by ravula sudheer

• Oct 18th, 2008

ab initio supports parallilesm..parallilesm 3 types 1.component parallilasem: graph running the data sumaltenously on seperate data uses. every component graph creates one component process ..this is ...

Answer Question  Select Best Answer

If a graph fails in between loading 1 millon records to a target table what is the alternative solution? I.e Will you run the grarh again? (The record count is very huge)

Raja

• Feb 10th, 2015

Its better to use check points and commit number in table to commit set of records before failing the graph

shan

• Oct 11th, 2012

Use checkpoints and partitions

Answer Question  Select Best Answer

I have already created graph,and need to modify it so that output file gets page breaks. Any idea how can we implement page breaks in abinitio.

Anu

• Jan 10th, 2020

Sed G filename

swarna

• Apr 10th, 2014

I think they mean inserting new line character in unix or
meaning carriage return in windows environment.

Answer Question  Select Best Answer

Hi Guys,

I have a requirement :

We need to design a graph for transition of some files. The details like filename, parameter_id (unique) we need to get from a table in DB and these should be included in the graph pset one at a time. That means for every unique parameter_id graph should run once.

Like we can have the parameter_id as the Job_name for the graph.

Satish

• Oct 8th, 2012

I am really not sure why you will have to create a dynamic PSet. That parameter file is for the static values but not the dynamic values. If you have some value witch is stored in the system and if yo...

Siva

• Jul 11th, 2012

You can use the air commands to create PSET for graph and add parameters to PSET. These commands can be executed in the wrapper scripts inside the while loop.

example/syntax:

air sandbox pset graph1.pset -protoype $PROJECT_DIR/mp/mygraph.mp

air sandbox parameter -path

Answer Question  Select Best Answer

What will be output for Inner join having no key when I/P in two respective Input Ports are:-
Input1 = 1,1 (one record with two fields)
Input2 = 1,1,1 (one record with three fields)?

vijayv

 Profile Answers by vijayv Questions by vijayv

• Feb 3rd, 2012

Yes, this is wonderful scenario.
in0:1,1
in1:1,1,2
when we are using inner join wil get 4 records
(1,1)(1,1)(1,1)(1,1).
when we are using cartesian join (with out key) wil get 6 records.
i.e. 2 X 3 records....(1,1)(1,1)(1,2)(1,1)(1,1)(1,2) records.
Thank you

P N Reddy

• Jan 12th, 2012

Yes you will get only one record when you have not given any key in join that will give you the cartisean product. since you have the inputs as in0-1record and ina-1record 1 cross 1 is 1. the output ...

Answer Question  Select Best Answer