1z1-448 무료 덤프문제 온라인 액세스

How do you reuse a configuration of OdiSendMail across multiple packages? (Choose the best answer.)

• A.Create a procedure with a step that usesOdiSendMailand add this procedure into multiple packages.
• B.Add anOdiSendMailstep to a knowledge module.
• C.Duplicate theOdiSendMail stepinto multiple packages.
• D.Add a sub-model to a package, set the Sub-model step to Journalizing Sub-model, and select the Extend Window and Lock Subscriber check boxes.

You are designing a Mapping. How are target and source tables defined? (Choose the best answer.)

• A.Their definition is imported with a reverse-engineering process directly from databases and other sources.
• B.An external engine must be run to describe what metadata is needed for a Mapping.
• C.Their definition is imported with areverse-engineering process directly from databases and other sources, but you must manually define all keys and constraints existing on the database.
• D.Forevery load the definition of the tables used, their columns and constraints must be manually built.

Which statement is true about the IKM SQL Control Append that creates an intermediate integration table prefixed with I$? (Choose the best answer.)

• A.IfFlow Control is not necessary, an I$ table is not created.
• B.Theintermediate integration table prefixed with I$ is createdbecause the flow control is mandatory when doing an initial load.
• C.Theintermediate integration table prefixed with I$is required to determine which records must be inserted.
• D.Neither the LKM northe IKM create intermediate tables. Most of their work is performed in the ODI Agent memory.

Which statement is true about defining more than one physical schema associated to the same data server? (Choose the best answer.)

• A.It is possible to define more than one physical schema associated to the same data server, but it is mandatory to specify a different user to log in.
• B.ODI topology does not allow defining more than one physical schema for a data server; the associated logical schema would be ambiguous.
• C.It is possible to define more than one physical schema associated to the same data server, but you must flag the default physical schema.
• D.It is possible but it is better to avoid doing so because it is more difficult to define a logical schema this way.

You must send the same message in multiple packages to several email addresses stored in the same database table. How do you accomplish this by using a reusable package step? (Choose the best answer.)

• A.Create a counter variable that gets the total number of email addresses stored in the database table. Next, create another variable that selects the email addresses from the database table. Then, create a loop in the packages by using the variables and anOdiSendMailstep.
• B.Create a procedure and add two tasks. The first one must have a Command on Source that reads the email addresses from the database table and stores them in a bind variable, and the second must have a Command on Target that usesOdiSendMailto send the email by using the bind variable defined in the first task.
• C.Createa Knowledge Module. Add a task with a Command on Source that reads the email addresses from the database table and stores them in a bind variable, and a Command on Target that usesOdiSendMailto send the email using the bind variable defined in the Command on Source.
• D.Create a procedure. Add a task with a Command on Source that reads the email addresses from the database table and stores them in a bind variable, and a Commandon Targetthat usesOdiSendMailto send the email using the bind variable defined in the Command on Source.