-
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
-
Order of Graph Execution
What is the order of execution of a graph when it runs?
Divya Sama
- Dec 14th, 2009
1. Initialisation of Parameters2. Start script execution3. Graph execution4. End script execution
shivhare.pankaj
- Nov 17th, 2009
1. All its parameters are initialized2. Start script call3. Graph start4. End script executed.
-
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...
-
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.
-
Sort within Group
What is the advantage of SORT within GROUP Clause?
veerahkvr
- Aug 22nd, 2009
Sort within Groups refines the sorting of data records already sorted according to one key and it sorts the records within the groups formed by the first sort according to a second key.
-
What command would you use to inspect the users currently logged into SQL Server database?
titli_n_titli
- Aug 14th, 2009
The below SQL Query can solve the purpose:select username from V$SESSION;
-
Abinitio MFS
There is one MF while loading data i deleted one partition in a MF? Can it show error/it will process data?
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
- 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.
-
Describe which system/process elements you would review when trouble-shooting general server slowness.
-
What is the name of the SQL language used in SQL Server stored procedures?
-
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
Abinitio Interview Questions
Ans