Which of the following you cannot use if you use DROP in data step?
KEEP
DELETE
REUSE
COMPRESS
How do you connect EME to Abinitio Server?
Using ab_project_setup.ksh
Using Run settings
Using EME Datastore Settings
None of the above
How to Create Surrogate Key using Ab Initio?
Using lookup() function
Using Generate Records component
Using re_index() function
Using next_in_sequence() function
What is a DB config file?
File used for database connectivity
File used to define data format
File used to hold lookup data
File used to store Data Byte size
Which one is the feature of a sort component?
Pipeline parallelism
Costly in terms of space and time
Removes duplicates on the key specified
How do you convert 4-way MFS to 8-way mfs?
Using Partition and Gather Components
Using Redefine Format Component
Using Reformat Component
Using Merge Component
Which function calculates the number of days between two dates?
Calculate_date_days()
Days_between_dates()
Date_difference_days()
Num_of_days()
Refer to a local lookup file
Define a local parameter
For parallel unloading from database
For serial unloading from database
How to generate the dml from an oracle table in AbInitio?
Using m_db unload command
Using m_db create dml command
Using m_db hosts command
Using m_db gendml command
Which component ensures component parallelism?
Partition
Replicate
Reformat
Sort