Skip to main content

Posts

Showing posts from March, 2020

Ranking in Abinitio

/*scan for rank number calculation /*scan for rank number calculation type temporary_type = record decimal("|") i; end /* Temporary variable*/; temp::initialize(in) = begin temp.i :: 0; end; --------------------------------- let string(",")[] vec =reinterpret_as(string(1)[],in.data); ---------------------------------------------------------------------- out::scan(temp, in) = begin out.i :: temp.i + 1; end; out::finalize(temp, in) = begin out.* :: in.*; out.rank_nbr :: temp.i; end; out :: output_select(out) = begin out :: out.rank_nbr == 1; end; ---------------------------------------- type temporary_type = record decimal("|") i; end /* Temporary variable*/; temp::initialize(in) = begin   temp.i :: 0; end; --------------------------------- let string(",")[] vectors =reinterpret_as(string(1)[],in.data); ---------------------------------------------------------------------- out::scan(temp, in) = begin   out.i :: temp.i + ...

SYNTEL INTERVIEW

3 Rounds Of Interview-->(1) Technical (2) Managerial (3) HR TECHNICAL ------------------- (A) SQL: (i) Query to find out 2nd highest salary (ii) 2 tables     Name| Sub |Marks       a     |B  |10       a     |C  |20       b     |B  |10       b     |C  |30       c     |B  |10       c     |C  |30 Query to to display all the records of a student where the  subject= C and its marks=30  alone (iii) Finding Top 10 values in a table UNIX (i) Cut command (ii) Need to display only the 2nd and 5th column data;delimiter is comma(,) (iii) Need to display records between 50 till 120 (iv) grep -i -v ? (v) How to check if a file is empty or not>? (vi) How to check whether the 3 parameters is passed or not?(Soln $# -eq 3) (vii) ls -ltr --...