-
How do you pass parameters to a graph in AI ?
sixto.dsilva
- Jun 25th, 2008
Yes you can declare parametes in edit paramter option in GDE, while running the ksh you can pass the value in command line.
High5
- Feb 16th, 2008
If you want to pass a parameter to your graph then declare a formal parameter in edit-parametrs region.
-
What is fan in and fan out in AI ?
Whats the difference and explain about usage?
abmaahi
- Mar 29th, 2010
Fan in flow is mainly used for sending data from partions to single file (departioning) and its vice versa fan out flow for partitioning.
sixto.dsilva
- Apr 17th, 2008
Fan in : fan in flow connects a component with a greater depth of parallelism to one with lesser depth thati s it folls a many to one pattern. example departition component.fan out : fan out is opposite of fan out example component is partition component.
-
What is wrapper script in Ab initio
anujaja
- Aug 25th, 2009
When you deploy an Ab Initio graph it becomes a ksh script saved in Run directory.Wrapper is another Unix script which calls the above mentioned deployed script.It might also be use to handle other functionalities together with execution of graph.
Sabitra S Panda
- Dec 10th, 2008
Wrapper script is an Unix script, which is helpful in running the graphs directly through Unix and running it automatically. This is useful when we have Unix as the operating system.
-
Pipeline Broken Error
Why and When do we get the "Pipeline Broken Error" in Ab Initio
Alok S
- Jan 17th, 2020
When total number of process in a unix box connecting to a particular user reaches the limit, it throws the error "pipeline broken". Which means no more connection to the user can be made. So wait for sometime and re-login.
cutesree
- Dec 29th, 2009
Pipeline broken error will actually indicates the?failure of a downstream component.It normally occurs when the database is?running out of memory?which makes?database components in the graph unavailable.
-
Indexes in Abinitio
In Abinitio which type of indexes used?
Sabitra S Panda
- Dec 10th, 2008
There is as such no concept of indexing in Ab Initio, since it is a code based ETL tool. Indexes come into picture on the database table side. But there is something called "output indexing" in Ab Ini...
sixto.dsilva
- Apr 15th, 2008
I think we don't have any concept of indexes in ab inition , it is there only in Database like table indexing to improve query performance of the tables.In Ab initio it is only massive parallel processing concept.
-
Production support for Ab Initio Graph
How do you do production support for Graph? How do you check whether graph is completed successfully or not (is it $? of unix?)What are different return values?
sham2sushil
- Apr 27th, 2010
If you running the Abinitio ksh file then you have to check the status using $? .$mpjret is using in the end script of the abinitio to check the abintio mp runs sucessfully or not.--Shambhu
sitharaju
- Mar 11th, 2009
How do you do production support for Graph? If the graph failed in the production, usually we get emergency access to see the failure, then analyse the failure, if it is a code bug, then we go back to...
-
Parametrization of MFS
I want to use an Ab Initio parameter to control whether I am in serial or MFS mode. Basically, I will have an $AI_MFS_PARTS variable. If it is set to 1, then we are running serial. If it is set to 4, then we are running 4-way MFS. Will the data need to be located in physically different locations using different control files?
sixto.dsilva
- Dec 6th, 2009
I think we can have two parameters like AI_SERIAL and AI_MFS to determine where we are in serial location or MFS location. This is best way of finding out whether the file is serial or MFS. Hope this help.
abhi_fresh_as_dew
- Dec 11th, 2008
Its always better to use multiple file system instead of adhoc multifiles.So,physical allocation is a good idea for separation of mfs and serial.Say,i have a physical allocation to path1 for mfs and h...
-
what is the function of XFR in abinitio
It would be great if one of you can explain me in brief what is the function of xfr (like what does it do ,where is it stored ,how does it affect ) as i am very confused on thisthank you
Shireesh
- Nov 14th, 2009
XFR is used for externalizing a transform/function. A function which needs to be reused at multiple places can be created as a common XFR instead of writing the same code again and again.
smarty.malik
- Dec 10th, 2008
The XFR usually stores the mappings in the text view. Usually these mappings are generalised. In the Transformation of any component these XFR's can be called and abi nitio will automatically do the s...
-
Unit testing
How do you perform Unit testing?
kalyanvadlamudi2kn
- Jan 10th, 2014
Turn on the debugging mode and insert the breakpoints for each transformation and see the results i.e. how are they evaluating in detail between variables,statements and business rules.
SnehaPandey
- Mar 10th, 2011
Divide the main components of graphs having required transformations and do data validation for each of them seperately.
-
SCD Types
How do we use SCD Types in the Abinitio graphs?
sudheer_abinitio
- Jun 8th, 2010
We phase 3 types of SCD.1. SLOWLY CHANGES DIMENSION TYPE 1 Having the current data. Latest data. Ex: 1 Record only 2. SLOWLY CHANGES DIMENSION TYPE 2 ...
abmaahi
- Apr 6th, 2010
Sorry the before answer is wrong.we can work out the scds with redefining the formats
-
Count Number of Records in Flat File
How can we count a number of records in a flat file using Abinitio?
abmaahi
- Apr 6th, 2010
Already two answers are there for your question one more method is you can youse the next_in_sequence() funcion
cutesree
- Dec 29th, 2009
Use rollup component to count the number of record in the flat file.Use {} as key in the key specifier. It will consider all the fields as one record and count the total number of records.
-
-
Abinitio Graph Phasing and Checkpoints
What is phasing & checkpointing? What is the use ?
-
-
Header details and trailer validation for multi file
my requirement
header contains - business date
details contains - reccords
trailler contains - total no of records in detail.
1) header , detail , trailer separation with indicator filed ( conditional dml with indicator field )
2)Comparing header with business date , if not match fail. ( using lookup with date function)
3)comparing the record count of... -
-
-
How to reuse transformed function into some other component
kalyanvadlamudi2kn
- Jan 9th, 2014
You have to use include in thXFR. We define all the common functions like strip blanks,format date etc., in a common xfr and can be used environment wide.
RAM
- Aug 17th, 2012
By the use of common xfr & by the use of include option
-
Difference between m_mkfs and m_touch
What is the difference between m_mkfs and m_touch.
Both create a MFS how do they differ ?
Also what is the syntax for creating MFS using m_touch -
Pick the Delta Data From Specific Files or Tables
If I run the graph at 9 O'clock, it should pick the data with the latest updated timestamp records like from 8 to 9 O'clock updated records from the table. How to pick the delta data from specific files or tables?
Mahesh
- May 26th, 2021
1 - if its a table it should have a column with timestamp and accordingly you filter out the records
2 - if its a file again if there is a timestamp column its easier, else read the file and look it up and join on key and timestamp, anything that does not join is new.irfan1patel1
- Jun 19th, 2017
You will definitely need a column in file or table which has the update timestamp. Based on timestamp you can simply filter the records using filter by expression
Abinitio Interview Questions
Ans