Ab Initio
Settings
AB INITIO Quiz
- 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
Back to top