Second fractions: What is the code, characters, string what so ever I need to use to handle second fractions in timestamps?

It is 'US', guess it stands for microseconds (μs) so probably PowerCenter supports 'only' up to 6 digits after the decimal point. An appropriate ISO format string could read thus 'YYYY-MM-DD HH24:MI:SS.US'.