-
What is the lookup function used to retrieve the particular duplictae datarecords in the lookup file
abhi_fresh_as_dew
- Jun 29th, 2009
Use lookup_count for finding the duplicates and lookup_next for retrieving it.If lookup_count (string file_label, [ expression [ , expression ... ] ] )>0lookup_next ( lookup_identifier_type lookup_id, string lookup_template ) Njoi!!Abhi - fresh as dew!
pradeep
- Nov 16th, 2006
Lookup_next function is used for retrieving duplicates records of that particular record
-
How to identify the Ascii , Ebcdic formats !how to write the DMl for same ..please explain ..
abhi_fresh_as_dew
- Feb 3rd, 2010
For ASCII formats write the DML as below.cust_id decimal(8)...For EBCIDIC formats write the DML as below.ebcidic cust_id decimal(8)...The delimiters varies in each and every ebcidic formats send from source files. But Its generally hexadecimal embedded.
AprilBlue
- Jan 10th, 2007
Ascii vs. EbcdicWhen you view your data does it have different charaters inbetween that do not look ASCII? If so, then in your record format type the following:ebcdic record record details...
-
-
Input Table component layout - Abinitio
My question is related to the INPUT TABLE component layout. If we select the layout to be DATABASE- (database default), where exactly is it pulling that layout from? When should this option be used? Within the DATABASE layout we also see the SERIAL ,TABLE and EXPLICIT args options, when do we use those? what are the advantages and disadvantages to this approach? Thanks
annegrace1
- Apr 8th, 2009
I would suggest you not to use the default database. either ai_serial or ai_mfs.Default database will pick the data from the database in the same structure as it is in db.The data in db might be serial or partition.
ankithak
- Oct 13th, 2007
Hi mahindra , I didnt get ur answer .If u dont mind pls give me clear explanation with example.
-
What are the commonly used or important functions used in the real time in Abintio
Mahendra
- Feb 13th, 2007
Hi Hema,I am not able to understand what is your requirement... see there are lot of functions available in the Ab Initio so we can not decide which function will be commonly used in Ab initio.. regards,mahendra
-
How do you join two files with different layouts
sitharaju
- Mar 11th, 2009
I think your question is to join a serial file and a multifile,?if that is the case use broadcast component after the serial file and before join.
Shilpi
- Aug 12th, 2007
If the layout is?totally different ----use Fuse Component
-
What is lock in abinitio?
SP
- Aug 31st, 2017
Lock is a version control mechanism in Abinitio. It is used to maintain data/code synchronization between EME and multiple sandboxes. It avoids to modifying the code simultaneously be different users at the same time.
sixto.dsilva
- Apr 18th, 2008
Lock mechanism is used by EME datastore to avoid confusion in the version control of a graph basically locking give a exclusive permission to modify and save it for a particular users and prevents other from making changes to the same file.
-
Explain real time environment of Ab initio?
pullarao
- Jan 16th, 2015
How to capture the delete records in abinitio
-
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 Interview Questions
Ans