Wednesday, 26 May 2021

Basic UNIX Interview Questions -

 



1) Unix Command to Check 32 bit or 64 bit - 
      uname -m

2) find  30 days older files in a directory?
      use find along with -mtime 

3) Find the files inside the directory and subdirectories?

4) Finding duplicates in a file?
    use sort along with uniq

5) sort the file based on a certain column?
   sort command with -c 

6) Check if the files exist or not?
-f in if statement

7) Check if the file is greater than the 0 bytes?
-s in if statement

8) Difference between grep and find command?

9) No. of parameters passed in the script?
 $#

10) how to Check the Status of the last executed Command?
 $?

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

           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?


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