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? - 

           grep -c 'word' file

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.

           I/P file - FBE - Lookup file ( append mode) 

           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

          Rollup - 

          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

          Reformat - 
          (length_of(in.data) -  length_of(re_replace(in.data,"anjali","")))/5

8) Ball Run scenario?

9) Finding Faulty records in the MFS file? 

          m_dump command with -show-partial 

10) Finding the files which are greater than 0 bytes in a directory?