topic [resolved] Set session setting to Query Teradata in Talend Studio

[resolved] Set session setting to Query Teradata

Anonymous — Wed, 25 Jun 2014 14:09:52 GMT

I am trying to use Dynamic datatype for list of tables integration using single job..
Its really helpful, thanks Talend.
But saying that, I need a little help to get this working well. My date values from the source are inconsistent, I mean they are 'mm/dd/rr' or 'mm/dd/yyyy' or 'yyyy-mm-dd'. as these are written in same fashion of string value to target, its not working out for me.
My source is teradata, so I tried setting the session dateform to ANSIDATE, which may help here. I am not able to configure the session using tTeradataInput.
Please help to setup values for the session at runtime, as we do in Teradata SQLA. I guess I can use that in different scenes as well.
Appreciate quick reply or any generic job available for the similar purpose.
Thanks,
Rahul

Re: [resolved] Set session setting to Query Teradata

Anonymous — Thu, 26 Jun 2014 04:43:54 GMT

Hi,
Schema must be defined during design, not run time. tTeradataInput does support for "Dynamic Schema" which allows you to design schema with an unknown column structure (unknown name and number of columns).
Please have a look at document: TalendHelpCenter:How to process changing data structure?.
Best regards
Sabrina

Re: [resolved] Set session setting to Query Teradata

Anonymous — Thu, 26 Jun 2014 16:41:07 GMT

I was able to manage the date values and its all working fine.
Dynamic data type is a wonderful inclusion...
Pleas let me know to close the request.
Thanks,
Rahul

Re: [resolved] Set session setting to Query Teradata

Anonymous — Thu, 10 Jul 2014 08:02:44 GMT

Hi,
You can click the "Set this topic as resolved" link which is right underneath your initial post. This way, other users will be informed that this thread has been resolved.
Best regards
Sabrina