Saturday, November 17, 2007

Case-sensitive string comparison

Can the Joiner transformation perform a case-sensitive string comparison as part of the join condition?

Choose Answer

(A)
Yes, always
(B)
No, the comparison is never case sensitive.
(C)
Yes when the Informatica server is running on the Unix operating system, no when it is running on a Windows operating system.
(D)
Yes, when the database that is being used for the join supports case-sensitive string comparisons.