<< Prev Question Next Question >>

Question 30/35

You want to create a job that checks conditions for your data before that data is loaded into a data
warehouse. The job should be able to detect error conditions such as missing data or duplicate data and
take appropriate actions like registering error conditions in log, etc. Which SAS Data Integration Studio
transformation should you use?

LEAVE A REPLY

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

Question List (35q)
Question 1: After creating a stored process from a SAS Data Integration ...
Question 2: In SAS Data Integration Studio, source table records and dim...
Question 3: You want to register an external file with the following str...
Question 4: The Platform Process Manager server is part of the Platform ...
Question 5: The profile reports generated in dfPower Profile jobs are vi...
Question 6: Assume that a SAS Data Integration Studio job is populating ...
Question 7: Which of the following is NOT defined as part of the New Lib...
Question 8: In SAS Data Integration Studio, which component allows the d...
Question 9: Which statement correctly defines a System DSN?...
Question 10: When using the SCD Type 2 load method in SAS Data Integratio...
Question 11: In SAS Data Integration Studio, which output format is suppo...
Question 12: The SAS Data Integration Studio SCD Type 2 Loader transforma...
Question 13: In SAS Data Integration Studio, the SCD Type 2 Loader transf...
Question 14: Which statement best describes the DataFlux Integration Serv...
Question 15: Within SAS Data Integration Studio, which one of the followi...
Question 16: SAS Data Integration Studio is dependent on which administra...
Question 17: How do you enable performance statistics for a SAS Data Inte...
Question 18: Within SAS Data Integration Studio, automatic mappings are d...
Question 19: In the following display, can status handling be enabled for...
Question 20: A user needs to find out who has the SAS Data Integration St...
Question 21: A SAS Data Integration Studio job was successfully scheduled...
Question 22: Assume that you have completed the Register Tables wizard in...
Question 23: Within SAS Data Integration Studio's SQL Join transformation...
Question 24: In SAS Data Integration Studio, primary keys, foreign keys a...
Question 25: When using the Table Loader transformation to load an existi...
Question 26: In SAS Data Integration Studio, where must the columns inclu...
Question 27: In SAS Data Integration Studio, an index can be specified/de...
Question 28: Which statement regarding propagation is FALSE?...
Question 29: Select the valid reasons for using SAS Data Integration Stud...
Question 30: You want to create a job that checks conditions for your dat...
Question 31: You want to create a table containing all customers from Ita...
Question 32: In SAS Data Integration Studio, which statement is FALSE reg...
Question 33: In SAS Data Integration Studio, surrogate and retained key v...
Question 34: Which statement is FALSE regarding foreign keys?...
Question 35: When using the Table Loader transformation in SAS Data Integ...