Below are some important SAP BO interview questions which are asked in most MNC company interviews for beginners or professionals.
41. What are the difference between Row-by-row select and Cached comparison table and sorted input in Table Comparison Tranform?
? Row-by-row select —look up the target table using SQL every time it receives an input row. This option is best if the target table is large.
? Cached comparison table — To load the comparison table into memory. This option is best when the table fits into memory and you are comparing the entire target table
? Sorted input — To read the comparison table in the order of the primary key column(s) using sequential read.This option improves performance because Data Integrator reads the comparison table only once.Add a query between the source and the Table_Comparison transform. Then, from the query’s input schema, drag the primary key columns into the Order By box of the query.
42. What is the use of using Number of loaders in Target Table?
Number of loaders loading with one loader is known as Single loader Loading. Loading when the number of loaders is greater than one is known as Parallel Loading. The default number of loaders is 1. The maximum number of loaders is 5.
43. What is the use of Rows per commit?
Specifies the transaction size in number of rows. If set to 1000, Data Integrator sends a commit to the underlying database every 1000 rows.
44. What is the difference between lookup (), lookup_ext () and lookup_seq ()?
? lookup() : Briefly, It returns single value based on single condition
? lookup_ext(): It returns multiple values based on single/multiple condition(s)
? lookup_seq(): It returns multiple values based on sequence number
45. What is the use of History preserving transform?
The History_Preserving transform allows you to produce a new row in your target rather than updating an existing row. You can indicate in which columns the transform identifies changes to be preserved. If the value of certain columns change, this transform creates a new row for each row flagged as UPDATE in the input data set.
46. What is the use of Map-Operation Transfrom?
The Map_Operation transform allows you to change operation codes on data sets to produce the desired output. Operation codes: INSERT UPDATE, DELETE, NORMAL, or DISCARD.
47. What is Heirarchy Flatenning?
Constructs a complete hierarchy from parent/child relationships, and then produces a description of the hierarchy in vertically or horizontally flattened format.
? Parent Column, Child Column
? Parent Attributes, Child Attributes.
48. What is the use of Case Transform?
Use the Case transform to simplify branch logic in data flows by consolidating case or decision-making logic into one transform. The transform allows you to split a data set into smaller sets based on logical branches.
49. What must you define in order to audit a data flow?
You must define audit points and audit rules when you want to audit a data flow.
50. List some factors for PERFORMANCE TUNING in data services?
The following sections describe ways you can adjust Data Integrator performance
? Source-based performance options
? Using array fetch size
? Caching data
? Join ordering
? Minimizing extracted data
? Target-based performance options
? Loading method and rows per commit
? Staging tables to speed up auto-correct loads
? Job design performance options
? Improving throughput
? Maximizing the number of pushed-down operations
? Minimizing data type conversion
? Minimizing locale conversion
? Improving Informix repository performance
41. What are the difference between Row-by-row select and Cached comparison table and sorted input in Table Comparison Tranform?
? Row-by-row select —look up the target table using SQL every time it receives an input row. This option is best if the target table is large.
? Cached comparison table — To load the comparison table into memory. This option is best when the table fits into memory and you are comparing the entire target table
? Sorted input — To read the comparison table in the order of the primary key column(s) using sequential read.This option improves performance because Data Integrator reads the comparison table only once.Add a query between the source and the Table_Comparison transform. Then, from the query’s input schema, drag the primary key columns into the Order By box of the query.
42. What is the use of using Number of loaders in Target Table?
Number of loaders loading with one loader is known as Single loader Loading. Loading when the number of loaders is greater than one is known as Parallel Loading. The default number of loaders is 1. The maximum number of loaders is 5.
43. What is the use of Rows per commit?
Specifies the transaction size in number of rows. If set to 1000, Data Integrator sends a commit to the underlying database every 1000 rows.
44. What is the difference between lookup (), lookup_ext () and lookup_seq ()?
? lookup() : Briefly, It returns single value based on single condition
? lookup_ext(): It returns multiple values based on single/multiple condition(s)
? lookup_seq(): It returns multiple values based on sequence number
45. What is the use of History preserving transform?
The History_Preserving transform allows you to produce a new row in your target rather than updating an existing row. You can indicate in which columns the transform identifies changes to be preserved. If the value of certain columns change, this transform creates a new row for each row flagged as UPDATE in the input data set.
46. What is the use of Map-Operation Transfrom?
The Map_Operation transform allows you to change operation codes on data sets to produce the desired output. Operation codes: INSERT UPDATE, DELETE, NORMAL, or DISCARD.
47. What is Heirarchy Flatenning?
Constructs a complete hierarchy from parent/child relationships, and then produces a description of the hierarchy in vertically or horizontally flattened format.
? Parent Column, Child Column
? Parent Attributes, Child Attributes.
48. What is the use of Case Transform?
Use the Case transform to simplify branch logic in data flows by consolidating case or decision-making logic into one transform. The transform allows you to split a data set into smaller sets based on logical branches.
49. What must you define in order to audit a data flow?
You must define audit points and audit rules when you want to audit a data flow.
50. List some factors for PERFORMANCE TUNING in data services?
The following sections describe ways you can adjust Data Integrator performance
? Source-based performance options
? Using array fetch size
? Caching data
? Join ordering
? Minimizing extracted data
? Target-based performance options
? Loading method and rows per commit
? Staging tables to speed up auto-correct loads
? Job design performance options
? Improving throughput
? Maximizing the number of pushed-down operations
? Minimizing data type conversion
? Minimizing locale conversion
? Improving Informix repository performance
No comments:
Post a Comment