In an ODI interface, is it possible to use a specific partition if it is declared for the target table to
load data?
A.
No, only generic loading can be declared and an IKM can declare partitions using options.
B.
No, only ODI variables can be used to filter the target table loading.
C.
Yes,an optioninthe interface can be used to declare partitions but an ODI variable must be used
to evaluate the correct partition value.
D.
Yes, an optioninthe interface can be used to declare the partition that has to be used for the
loading.
Explanation:
Ans D
if you want to target a specific partition in the target datasource select in the property inspector the partition defined for this datasource from the list
Answer is C
Create a variable #PV
Using IKM Oracle PEL, set Option Name: APARTITION_VARIABLE = #PV
cahobeika, I agree with you, but how does this make C the right answer?
The option is in the IKM (so A), as opposed to an interface option (C and D)?
I’d definitely choose A as the interface itself woudn’t allow anything for a technology that has no dedicated partition-aware KM.
D is correct