20 TOP ETL Testing Multiple Choice Questions and Answers

List of top 20 most frequently asked ETL Testing multiple choice questions and answers pdf download free

ETL Testing Multiple Choice Questions and Answers List

  1. All data in flat file is in this format.
  2. It is used to push data into a relation database table. This control will be the destination for most fact table data flows.
  3. Logical Data Maps
  4. Data access methods.
  5. OLTP
  6. COBOL
  7. What ETL Stands for
  8. The source system initiates the data transfer for the ETL process. This method is uncommon in practice, as each system would have to move the data to the ETL process individually.
  9. Sentinel Files
  10. Checkpoints
  11. Mainframe systems use this. This requires a conversion to the more common ASCII format.
  12. Ultimate flexibility, unit testing is available, usually poor documentation.
  13. Conditional Split
  14. Flat files
  15. 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.
  16. 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.
  17. Shows the path to the file to be imported.
  18. Wheel is already invented, documented, good support.
  19. Similar to XML’s structured text file.
  20. Flat file control

This entry was posted in Multiple Choice Questions. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *