Wednesday, 26 May 2021
Basic UNIX Interview Questions -
Wednesday, 12 May 2021
Virtusa Abinitio Interview Questions -2021
1) 3 ways to Remove Duplicates in Abinitio? -
Rollup key change, Dedup ,Rollup first and last function.
2) List out directories in one column? ls -l
3) Counting occurrences of words in a file using Unix? -
4) Methods to Sequentially load the data?
example - 1st-day load 10 data from an input file, next day 10 to 20 records, and so on.
FBE - !lookup_match("lookup",in.data) and next_in_sequence()<=10
5) How to Divide the file based on condition?
partition by expression, filter by expression.
6) Scenario -
Input -
A 100 NULL
A NULL 300
B 200 400
B NULL NULL
Output -
A 100 300
B 200 400
I/P file - Rollup -O/P
Key - id
Transform -
Out.id ::in.id;
Out.col1 :: string_filter_out(concatenation(in.col1),”NULL”);
Out.col2 :: string_filter_out(concatenation(in.col2),”NULL”)
7) How to count the occurrence of anjali in a string?
example - anjalimishraanjalimishraanjalimishraanjalimishra
(length_of(in.data) - length_of(re_replace(in.data,"anjali","")))/5
8) Ball Run scenario?
9) Finding Faulty records in the MFS file?
10) Finding the files which are greater than 0 bytes in a directory?
how to create dml dynamically in Ab-initio
$[ begin let int i = 0; let string(int) complete_list = "emp_nm,billable,age,designation,location"; let string(int) file_content ...
-
1) air tag diff - ->air tag diff -show-all tag1 tag2 (-show-all -optional list objects for which there are no differences) 2) air tag c...
-
1) How to print records from a file where cust_id started with 1234 by using the m_dump command ? m_dump dml data -select 'starts_with(c...
-
$[ begin let int i = 0; let string(int) complete_list = "emp_nm,billable,age,designation,location"; let string(int) file_content ...
