-
How to achieve the below scenario in abinitio
Input file has below contents:
Ball Run
1 1
2 1
3 1
4 1
5 1
6 1
1 0
2 1
3 1
4 1
5 1
6 1
1 1
2 1
3 1
4 1
5 1
6 0
Required Output :
1 6
2 5
3 5 -
Wat is the difference between rollup and scan?
veer
- Jul 17th, 2023
Rollup Summarizes data by grouping records and applying an aggregate function to each group. The finalize transform function is applied to a group of records to produce an output record. The number...
-
Why go for sort within groups?
We have sort and sort within groups components. we can achieve the sort within group functionality by placing two keys in sort group. Then why we have to go for sort within groups?
-
Abinitio EME
In my sandbox i am having 10 graphs, i checked-in those graphs into EME. Again i checked-out the graph and i do the modifications, i found out the modifications was wrong. what i have to do if i want to get the original graph..?
-
Output for sort and dedup sort with null key
I have file containing 5 unique rows and I am passing them through SORT component using null key and and passing output of SORT to Dedup sort. What will happen, what will be the output.
-
Fetch Next Record Data
How can we fetch next record data for a particular field in ab initio?
i/p
id sal
101 500
102 800
103 900
105 200
o/p
id sal Pre_sal
101 500 0
102 800 500
103 900 800
105 200 900Sai
- May 14th, 2018
use scan component we have to achieve this scenario and the parameter key is "NULL({})"and find the below explanation.Here i am taking the 2 temporary variables as a,b. type temporary_type = record ...
neha.nagare
- Apr 26th, 2018
We can achieve this by using reformat component by maintaining current and previous value of the column sal and by updating variable prev_sal with previous record value of column sal. Please find...
-
Rollup Component as Scan Component
How to use rollup Component as Scan Component? On what condition Rollup component can be used as SCAN?
-
Record to Column
I have a record like below:
avi,mahi,virat,mahi,avi,virat,mahi,virat,avi
Output should be:
avi1
mahi1
virat1
mahi2
avi2
virat3
mahi3
virat4
avi3
Please suggest how can I achieve this.neha.nagare
- Apr 26th, 2018
Flow I/p ->normalize ->scan->o/p We can achieve this by using normalize and scan component ,make vector by using string_split function and assign size of the vector to the length function of the no...
Sandeep
- Mar 25th, 2018
Use scan component using check sort attribute as false(maintain order-false)
then use name as key and for sequence number use count(in.name) -
Interpretation and its use
What is Interpretation in Abinitio? What are types of interpretations available and its uses? Where do we use each interpretation?
-
-
Not Selecting Lookups Record
I have data like below.
source file:
EmpID sal
A 1000
B 2000
C 3000
D 4000
Lookup File
EmpID
A
B
Output File
EMPID Sal
C 3000
D 4000
I want empId, sal of employees those not present in lookup file -
Cummulative summary in AB Initio
How can I achieve cummulative sumary in AB Initio other than using SCAN component. Is there any inbuilt function available for that?
mk_44
- Feb 9th, 2016
I guess below code can help for 3rd max else 1st max for each group key. Input_file --> sort (descending) --> Rollup --> output type temporary_type=record decimal("") rank ; decimal("") sal ...
disha
- Jan 22nd, 2016
@Dinesh: but it is not taking care of the requirement, i.e. if there is no 3rd record, it should display the first highest sal. In the solution you mentioned it will display the second highest sal.
-
Generate Sequence Number in a Multifile.
How to generate sequence number in a multifile using next_in_sequence().
-
What is Ab local?
seemabuchhada
- Mar 15th, 2014
In most cases you are unloading enough data to require a parallel unload. Adding the ABLOCAL(tablename) clause to your SQL statement prevents the Input Table component from parsing the SQL and specifi...
sham2sushil
- Oct 27th, 2010
The use of ABLOCAL() construct is in Some complex SQL statements contain grammar that is not recognized by the Ab Initio parser. When data is unloading in parallel. Then ABLOCAL() construct ...
-
-
What is Pset file in Abinitio?
sham2sushil
- Oct 23rd, 2010
.pset file is an input values or input parameters set file. By using the air sandbox run command we can run the .pset file. Internally calling the .mp file and passing all the inputs parameter during run time.--Shambhu
-
Wrapper Scripts
What are Wrapper scripts? What does it contain?
abmaahi
- Jul 19th, 2010
Wrapper scripts are unix scripts,they also known as calling scripts.they used to run the deployed scripts.in the order what se can specify in the unix script
-
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...
-
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.
-
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...
Abinitio Interview Questions
Ans