Ab Initio

50 Questions | Total Attempts: 1551

Settings
Please wait...
Software Quizzes & Trivia

AB INITIO Quiz


Questions and Answers
  • 1. 
    Select the list of departition components from the below
    • A. 

      Gather

    • B. 

      Merge

    • C. 

      Filter by Expression

    • D. 

      Roun Robin

    • E. 

      Intereave

    • F. 

      Concatenate

  • 2. 
    Is it possible to increase the count vaue of reformat ?
    • A. 

      True

    • B. 

      False

  • 3. 
    In memory sort is present in DeDup component
    • A. 

      True

    • B. 

      False

  • 4. 
    Use of Generate component
    • A. 

      To collect the junk data

    • B. 

      Act as an inter mediate file

    • C. 

      Generate random records

  • 5. 
    • A. 

      Concat

    • B. 

      Merge

    • C. 

      Interleave

    • D. 

      Gather

  • 6. 
    Adhoc Multifile is parallel file, but not stored in a multiple directory
    • A. 

      True

    • B. 

      False

  • 7. 
    Usage of intermediate file do not increase the phase
    • A. 

      True

    • B. 

      False

  • 8. 
    Which command is use to generate dml
    • A. 

      M_db generate dml

    • B. 

      M_db gendml

    • C. 

      M_db gen

  • 9. 
    2 important keys used in sort within group
    • A. 

      Major key

    • B. 

      Minor Key

    • C. 

      Both

    • D. 

      None of the above

  • 10. 
    Is it possible to extract data from 2 different source or database using AB INITIO graphs
    • A. 

      True

    • B. 

      False

  • 11. 
    Which is the command used in GDE to run unix commands
  • 12. 
    • A. 

      Concat

    • B. 

      Merge

    • C. 

      Gather

  • 13. 
    • A. 

      When the input file is not given properly

    • B. 

      When the layout is not specified properly

    • C. 

      When the dml and data is not matching

  • 14. 
    When we use force_error, the parameter reject_threshold should be never abort
    • A. 

      True

    • B. 

      False

  • 15. 
    Parameters involved in Run sql component
    • A. 

      Num_error

    • B. 

      SQLFile

    • C. 

      DB Config File

  • 16. 
    • A. 

      Delete table component

    • B. 

      Truncate table component

    • C. 

      Run table component

  • 17. 
    • A. 

      Change the value

    • B. 

      Change the field name

    • C. 

      Change the data type

  • 18. 
    • A. 

      1

    • B. 

      2

    • C. 

      10

  • 19. 
    • A. 

      ((next_in =sequence()-1)*number_ofpartition()+this_partition())

    • B. 

      ((next_in =sequence()-1)*number_ofpartition()+this_partition())+1

    • C. 

      ((next_in =sequence()-1)+number_ofpartition()+this_partition())+1

  • 20. 
    • A. 

      M_mkfs

    • B. 

      M_db_mkfs

    • C. 

      M_mfs

  • 21. 
    • A. 

      Rm rec_file

    • B. 

      M_rm rec_file

    • C. 

      M_rollback -d rec_file

  • 22. 
    In conditional component, value 1 will pass the records, value 0 will disable the component or the subgraph
    • A. 

      True

    • B. 

      False

  • 23. 
    Which parameter will help us to find the status of the exectued graph
    • A. 

      $AB_GRAPH

    • B. 

      $mp_graph

    • C. 

      $mpjret

  • 24. 
    By doing what the output file is changed into a lookup file
    • A. 

      Using intermediate file

    • B. 

      Click add to catlog in output file component

    • C. 

      Using adhoc multifile

  • 25. 
    Which component is used to run the shell script
    • A. 

      Run SQL

    • B. 

      Run Program

    • C. 

      Join with DB

  • 26. 
    To take the data from 1st to specific record which component form the below i should use
    • A. 

      Join with DB

    • B. 

      Leading records

    • C. 

      Trash

  • 27. 
    • A. 

      Intermediate file

    • B. 

      Look file

    • C. 

      Gather Log

  • 28. 
    Replicate is a component which do not gather all the data records into one single flow.
    • A. 

      True

    • B. 

      False

  • 29. 
    Which component break pipeline parallelism
    • A. 

      Intermediate file

    • B. 

      Look up file

    • C. 

      Sort

    • D. 

      All the above

  • 30. 
    • A. 

      Replicate

    • B. 

      Gather

    • C. 

      Filter by Expression

    • D. 

      Redefine

  • 31. 
    • A. 

      Replicate

    • B. 

      Redefine

    • C. 

      Trash

    • D. 

      All the above

  • 32. 
    Select the list of partition component from the below list
    • A. 

      Partition by Key

    • B. 

      Partition by load balance

    • C. 

      Partition by expression

    • D. 

      All the above

  • 33. 
    By default what is the count of reformat and multireformat
    • A. 

      Reformat count 1, multireformat 2

    • B. 

      Reformat count 1, multireformat 1

    • C. 

      Reformat count 2, multireformat 1

  • 34. 
    Co>Op is optional in AB INITIO
    • A. 

      True

    • B. 

      False

  • 35. 
    EME is optional in AB INITIO
    • A. 

      True

    • B. 

      False

  • 36. 
    Its not possible to run an AB INITIO graph without GDE
    • A. 

      True

    • B. 

      False

  • 37. 
    Is it possible to do a check in / check out using GDE ?
    • A. 

      True

    • B. 

      False

  • 38. 
    Unix command to do check in
    • A. 

      Air project import -basedir

    • B. 

      Air project export -basedir

    • C. 

      Air project -basedir

  • 39. 
    • A. 

      Partition by expression

    • B. 

      Filter by expression

    • C. 

      Scan

  • 40. 
    • A. 

      String_trunc()

    • B. 

      String_lrtrim()

    • C. 

      String_del()

  • 41. 
    • A. 

      +26abc

    • B. 

      +26abc

    • C. 

      +26

  • 42. 
    Whats the output of this excpressionis_define(NULL)
    • A. 

      1

    • B. 

      0

    • C. 

      NULL

  • 43. 
    • A. 

      1

    • B. 

      0

    • C. 

      " "

  • 44. 
    Join types in AB INITIO
    • A. 

      Inner,full outer, explicit

    • B. 

      Semi join, left outer, right outer

    • C. 

      Inner, left outer, right outer

  • 45. 
    While doing a join, key form one flow is id and from other flow is emp_id.Using which from the below i can use this 2 keys to join
    • A. 

      Driving port

    • B. 

      Overriding

    • C. 

      Dedup

  • 46. 
    How to touch a multifile
    • A. 

      Touch filename

    • B. 

      M_touch filename

    • C. 

      Both

  • 47. 
    What happens when the data for join is not in sorted order
    • A. 

      Graph fails

    • B. 

      Graph executed

    • C. 

      Get struck

  • 48. 
    What happens when data for merge  is not in a sorted order
    • A. 

      Grpah fails

    • B. 

      Graph does not fail, not correct output

    • C. 

      None of the above

  • 49. 
    Trash component cannot store any output data
    • A. 

      True

    • B. 

      False

  • 50. 
    What are the types of parallelism in AB INITIO
    • A. 

      Data,component,pipeline

    • B. 

      Component, process,data

    • C. 

      Pipeline,connection,data