Current Time from Column Generator
Posted: Wed Oct 04, 2006 1:35 am
Hi All,
I have a requirement where i need to update a field(LAST_UPDATE_TIME) in a table with the current timestamp, when a record gets updated. I can very well use a parallel transformer and use a CurrentTimestamp() function. But wanted to check if we can use any other stage to get this requirement done. Basically i am trying to avoid the usage of a transformer.
Is there a way we can generate a current timestamp (like sysdate) using a "Column Generator/Row Generator" Stage ? if yes, can you please let me know the parameters ? When i tried it gives the default date (1960-01-01). I am using a sequential file as source.
Thanks for the clarification.
-Sid
I have a requirement where i need to update a field(LAST_UPDATE_TIME) in a table with the current timestamp, when a record gets updated. I can very well use a parallel transformer and use a CurrentTimestamp() function. But wanted to check if we can use any other stage to get this requirement done. Basically i am trying to avoid the usage of a transformer.
Is there a way we can generate a current timestamp (like sysdate) using a "Column Generator/Row Generator" Stage ? if yes, can you please let me know the parameters ? When i tried it gives the default date (1960-01-01). I am using a sequential file as source.
Thanks for the clarification.
-Sid