Tuesday, December 23, 2014

Sentinel Files | ETL Testing Questions

A.  These are used to identify which fields from which sources are going to with destinations. It allows the ETL developer to identify if there is a need to do a data type change or aggregation prior to beginning coding of an ETL process.
B.   These can be used to flag an entire file-set that is ready for processing by the ETL process. It contains no meaningful data bu the fact it exists is the key to the process.
C.    ETL can be used to automate the movement of data between two locations. This standardizes the process so that the load is done the same way every run.
D.   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.
Ans:  B

No comments: