Skip to main content

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 --> full form
(viii) /home/syntel --->need output as /homesyntel

ABINITIO

(1) Need a component which can seperate 3 cities and can also perform transform on them simultaneously----->RFM,output_index

(ii) Rollup Expanded mode:
    
type_temporary_type
Initialize
Rollup
Finalize
How many time the initalize,finalize and rollup will be called ?

(iii)Scan --same as above and difference

(iv) How to confirm that the particular table is a SCD and its type

(v) Which type are u using in ur Project and how did u implement it ***

(vi) What is driving Port and how is it enabled

(vii) (serial file)---->RFM---->(Serial File)
  How to improve performance and reduce time/detail tracker

(viii) File Balancing logic

(ix) Partitioning component and advg of Round Robin and to nullify its effect

(x) Difference between Broadcast and Replicate

(xi) Diff between Concatenate and Gather and Merge.Will Merge accept Non Sorted input?




MANAGERIAL ROUND

(i) Select * from T1,T2;---->Cartesian Pdt

(ii) Surrogate Key and example?

(iii) Different type of SCD and diff between SCD 2 and 3?

(iv) Complex scenario?

(v) Multifile system

(vi) EMP# | Dept | Flag



Want the count of Employee,grouped on Dept where the active Employee sterength is more than 10

Popular posts from this blog

UNIX - AIR COMMANDS

air object changed: Compares two branches or versions of a single technical repository or two repositories, and identifies which objects have changed.    The command outputs the list of files that have been added, removed, or changed between the source and target as follows: Code (meaning) Description A  (Added) The file exists in the target but not in the source. R  (Removed) The file exists in the source but not in the target. M  (Modified) The file is different in the source and the target. S  (Same) The file is the same in the source and the target. U  (Unknown) The difference could not be determined. Occurs due to permission errors or when an object cannot be checked out. N  (No object) The specified object does not exist in either the source or the target. air tag diff: ...
Read more

AB INITIO - LOOKUP FUNCTION

                                                LOOKUP FUNCTION   lookup_next() §   Lookup_next will give you the next available match in the Lookup file. §   Lookup_next should be Preceded after successful call to lookup, lookup_count, lookup_match, lookup_nth, lookup_range, or lookup_next itself. §   The lookup_next function returns NULL if you call it more times than the number of matching records in the file, or if the next matching record does not exist. §   Behavior of lookup_next() on different calls                   The next successive matching record after the previous call to lookup or lookup_range .  ...
Read more

TERADATA-PIVOT FUNCTION

                                  PIVOT FUNCTION §   Splits records by data fields (Columns) §   Converts Rows to Columns or Columns to Rows §   Converts an input records into multiple output records.                                                                      EXA MPLE Execute the below query for the results. §   Before pivot query:             sel cost_cntr_id , DATASET_NBR , cat , r...
Read more