QUESTION
NO: 1
Which
two ODI knowledge modules are included in the Application Adapter for Hadoop?
A.
IKM Oracle Incremental Update
B.
IKM Hive Transform
C.
IKM SQL to File Append
D.
IKM FiletoHive
Answer:
B,D
Reference:http://docs.oracle.com/cd/E27101_01/doc.10/e27365/odi.htm
QUESTION
NO: 2
When
working with delimited flat files, is it possible to enforce primary key on a
flat file using a CKM?
A.
No, it is not possible to enforce constraints on some technologies such as flat
files and JMS queues.
B.
No, it is not possible to enforce constraints on any technology.
C.
Yes, it is possible also to forward-engineer it to the flat file definition.
D.
Yes, but you have to save it as a fixed file.
Answer:
A
QUESTION
NO: 3
You
want to add a new CDC subscriber in ODI after you have started the Journal
process, what steps do you need to go through in order to use this new
subscriber?
A.
Drop Journal, remove existing subscribers, add a new subscriber, start Journal,
and edit the default Journalizing filter in your Interfaces
B.
Drop Journal,add anew subscriber, start Journal, and remove the default
Journalizing filter in your Interfaces
C.
Drop Journal, add a new subscriber, start Journal, and edit the default
Journalizing filter in your Interfaces
D.
Add anew subscriber and edit the default Journalizing filter in your Interfaces
Answer:
C
QUESTION
NO: 4
You
are loading a file into a database but the file name is unknown at design time
and will have to be passed dynamically to a Package at run time; how do you
achieve this?
A.
Create a variable, use it in Topology at the File dataserver-level, and add it
to a package as a Declare Variable step
B.
Create a variable, use it in Topology at the File dataserver-level, and add it
to a package as a Set Variable step
C.
Create a variable, use it as the Resource Name of the File datastore, and add
it to a package as a Declare Variable step
D.
Create a variable, use it as the Resource Name of the File datastore, and add
it to a package as a Set Variable step
Answer:
D
QUESTION
NO: 5
Select
the two correct statements about the Date Profiler.
A.
It can profile string dates written in a variety of formats, such as DD/MM/YYYY
or
MM/DD/YYYY.
B.
It provides a distribution for the day in the year, such as February 21, regardless
of the year.
C.
It allows the EDQ user to define a valid range of dates.
D.
By clicking a date in blue, the user can drill down to the records that carried
that value.
E.
It rejects February 29 as an invalid date.
Answer:
A,D
0 Comments:
Post a Comment
Subscribe to Post Comments [Atom]
<< Home