Category Archives: ETL Testing MCQs

Flat file control | ETL Testing Mcqs

A. Three components of data flow. B. It is used to import text files for ETL processing. C. The easiest to consume from the ETL standpoint. D. Shows the path to the file to be imported. Ans: B

Posted in ETL Testing MCQs | Leave a comment

Similar to XML’s structured text file. | ETL Testing Mcqs

A. Data Scrubbing B. EBCDIC C. String D. Web Scraping Ans: D

Posted in ETL Testing MCQs | Leave a comment

Wheel is already invented, documented, good support. | ETL Testing Mcqs

A. Format B. COBOL C. Tool Suite D. Flat files Ans: C

Posted in ETL Testing MCQs | Leave a comment

Shows the path to the file to be imported. | ETL Testing Mcqs

A. File Name B. Mainframe C. Format D. Union all Ans: A

Posted in ETL Testing MCQs | Leave a comment

There are little to no benefits to the ETL developer when accessing these types of systems and many detriments. The ability to access these systems is very limited and typically FTP of text files is used to facilitate access. | ETL Testing Mcqs

A. Mainframe B. Union all C. File Name D. Multicast Ans: A

Posted in ETL Testing MCQs | Leave a comment

This is used to create multiple streams within a data flow from a single stream. All records in the stream are sent down all paths. Typically uses a merge-join to recombine the streams later in the data flow. | ETL Testing Mcqs

A. OLTP B. Mainframe C. EBCDIC D. Multicast Ans: D

Posted in ETL Testing MCQs | Leave a comment

Flat files | ETL Testing Mcqs

A. The easiest to consume from the ETL standpoint. B. Three components of data flow. C. Three common usages of ETL. D. Two methods to ensure data integrity. Ans: A

Posted in ETL Testing MCQs | Leave a comment

Conditional Split | ETL Testing Mcqs

A. Many routines of the Mainframe system are written in this. B. Data is pulled from multiple sources to be merged into one or more destinations. C. It allows multiple streams to be created from a single stream. Only rows … Continue reading

Posted in ETL Testing MCQs | Leave a comment

Ultimate flexibility, unit testing is available, usually poor documentation. | ETL Testing Mcqs

A. ETL B. Custom C. OLTP D. Sort Ans: B

Posted in ETL Testing MCQs | Leave a comment

Mainframe systems use this. This requires a conversion to the more common ASCII format. | ETL Testing Mcqs

A. ETL B. XML C. Sort D. EBCDIC Ans: D

Posted in ETL Testing MCQs | Leave a comment