Frequently asked Abinitio Interview Questions 2021

1) What is Replicate? 

    Hint - Replicate arbitrarily combines all the input record it received in a single flow and     writes a copy of data to each of its output flow, Supports component parallelism.

 2) What is Broadcast?

   Hint - Broadcast arbitrarily combines all the input record it received in a single flow and writes a copy of the data to each flow partition, to increase data parallelism. 

 3) Difference between Broadcast and Replicate? 

 4) Command to checkin the Object in Repository? 

   Hint- air project import

 5) Command to Checkout an object from Repository? 

 Hint - air project export

 6) Scenario - Finding max Transaction date and 5 Transactions Amount? 

 example - 

 Input -cust_id transcation_dt transcation_amount

 output - max transcation dt and 5 transcation amount. 

 7) What is SCD1 and SCD2. 

 8 ) Scenario - 

 Input - 

ZEBRA 

ELEPHANT 

 Output- Z 

ZE

ZEB 

ZEBR

ZEBRA

E 

EL

ELE

ELEP

ELEPH

ELEPHA

ELEPHAN 

ELEPHANT 

Hint - i/p file -> Normalize ->Output file out::length(in)= begin out :: string_lengthe(in.id); end; out::Normalize(in,index)= begin out.id :: string_substring(1,index); end