-
Explain what is lookup?
sham2sushil
- May 2nd, 2010
Lookup File consists of data records which can be held in main memory. Lookup is basically a specific dataset which is keyed. This makes the transform function to retrieve the records much faster th...
Ashim Dutta
- Oct 20th, 2005
Lookup is basically a specific dataset which is keyed. This can be used to mapping values as per the data present in a particular file (serial/multi file). The dataset can be static as well dynamic ( ...
-
Range Lookup
What is Range Lookup?
sham2sushil
- May 2nd, 2010
Its returns the first data record When you defined the range indicated by the lower and upper bound arguments. --Shambhu
-
How does component folding works in Ab Initio?
sham2sushil
- Apr 27th, 2010
It reduces the number of processes created by the graph and can enhance performance of the graphs. It is combined saveral graph componants at a time in a group during run. groups runs as a single process and use the less memory during runtime.--Shambhu
-
Convert 4 way mfs to 8 way mfs
How to convert 4 way to 8 way mfs files without throw down of data in the file?
sham2sushil
- Apr 27th, 2010
1. To convert 4 way to 8 way partition we need to change the layout in the partioning component.2. Departition the data then repartition.--Shambhu
-
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...
-
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.
-
How to create SCDs(slowly changing dimensions) in abinitio?
abmaahi
- Apr 6th, 2010
Scds means its slowly changing dimension in sizes like int to long data types. we will work out scds with delta processing or redefining the formats by redefine format. thats it .dont take tension any more dont get confuse.
biyyanimv
- Mar 8th, 2009
If you want to implement the SCDs in abinitio then you should do the delta processing
-
Force_Error with Condition
How to pass force_error with condition?
DilipPanda
- Apr 4th, 2010
You can write force_error function in following fashionout:reformat(in)beginif (in.cust_name=="XYZ") force_error("Invalid Customer");out.*::in.*endHope this helps...
-
What is the difference between a Scan component and a RollUp component?
DilipPanda
- Apr 4th, 2010
Finalize function of SCAN Component is called for each record for a group where as for rollup component it called only once.
satish kumar
- Apr 23rd, 2006
Roll up generates data records that summarizes group of data records the rollup can be used to perform the data aggregatuin like sum,avg,max,min etcScan component generates a series of cumulative summary records such as successive yera to date totals for group of data records
-
Append Records
How do we append records to an already existing file usin abinitio graph?
abmaahi
- Apr 2nd, 2010
if you want to append the record to same out put file just go to acess in properties window there you will find the option s uncheck the option "delete file if tits exit" and check the...
Mihira Barik
- Nov 9th, 2009
Create a graph by taking the existing file as?the out put file and keep the mode of the output file in Append Mode. Pass the?new records from the input file?to this?output file through a?reformat. This will append new?records in the existing File.
-
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.
-
Changing to MFS
How do change serial file into MFS? Explain
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
- 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
-
-
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...
-
Behaviour of Component in Differnt Version
How will you ensure that the components created in one version do not malfunction/cease functioning in other version?
abhi_fresh_as_dew
- Feb 3rd, 2010
Components should be compatibile to run in previous versions of GDE. The depreciated components would run in new versions.
bhangale_kishor
- Dec 29th, 2009
Runtime behaviour of components will remain same in all versions unless its requires to have any additional paramter to be defined in any version. Evolution of new version of ETL comes with some changes in component level parameters (observation as of now).
-
Abinitio Lookup
Can we process 1 GB data(1 million records) by using Lookup? How
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.
-
Record counts by Reformat Component
How to calculate the total number of records in the file using REFORMAT instead of ROLLUP?
biyyanimv
- Dec 29th, 2009
Connect reformat to log port and use this code and in select parameter specify event_type="finish"type reformat_final_msg = recorddecimal("records") read_count; string("readn&...
-
Open Abinitio in UNIX
How to open Abinitio in UNIX?
cutesree
- Dec 30th, 2009
We cannot open AB Initio in UNIX. We can only run graphs in UNIX using the ksh.
-
Whats the best way in a AI GRAPH to read the header 1st line and trailer (last line) in a i/p file, compare record counts and checksum (available in header) and error out if actual recd count or checksum did not match?
sham2sushil
- Dec 16th, 2009
anujaja, use only one dedup sort. in dedup sort use the select statement "next_in_sequence > 1" and use keyless Dedup "{}". With keep paramete "last". this will remove trailer, you will get all the body part from the "dup" port-Shambhu
anujaja
- Aug 25th, 2009
You can also use a keyless Dedup with keep parameter as first.This will put header in output port and rest of the record on Dup port . Then connect dup port again with another dedup and use Keep parameter as last this will remove trailer as well.
-
Where we keep the control file (controle partition)
sham2sushil
- Dec 16th, 2009
Ab Initio multifiles present in parallel directories called multidirectories, which are present into multifile systemsThe multidirectories contain the control file (controle partition) and data directory.-Shambhu
shashi_dhar
- Feb 19th, 2007
Control should present in the multifile directory, which contains the address of the serial files
Abinitio Interview Questions
Ans