topic Re: Extract dynamic fields in job in Talend Studio

Extract dynamic fields in job

_AnonymousUser — Wed, 04 Apr 2012 07:45:46 GMT

Hello,
Can someone provide me with some info on how to retrieve dynamic fields in a job?
I have used tExtractFields step, but in this step I have to specify the column names which I have to retrieve. Is there any way to retrieve all dynamic fields in the stream??
Thanks in Advance
Rashmitha

Re: Extract dynamic fields in job

Anonymous — Wed, 04 Apr 2012 13:25:57 GMT

Hi Rashmitha
Which version of Talend product do you use?
The dynamic feature is only available in Talend Integration Suite(Commercial Version).
Regards,
Pedro

Re: Extract dynamic fields in job

_AnonymousUser — Wed, 04 Apr 2012 13:31:31 GMT

Hi Pedro,
I am using TIS-PE 4.2.3
Regards,
Rashmitha

Re: Extract dynamic fields in job

Anonymous — Wed, 04 Apr 2012 13:52:25 GMT

Hi Rashmitha
You can follow the steps of Chapter Dynamic Schema in TalendIntegrationSuite_UG_xxx_EN.pdf.
For TIS document, you will get from Talend Support Team.
Regards,
Pedro

Re: Extract dynamic fields in job

_AnonymousUser — Wed, 04 Apr 2012 16:40:43 GMT

Hi Pedro,
Yes, I have gone through the document. But my problem is while extracting the columns from Dynamic schema, I will have to mention the column names in the steps, but these column names are known to me only at runtime.
So I wanted to know how to retrieve these dynamic columns.
Basically I have to validate these columns dynamically, but dynamic schema is not supported by DQ components. So, I was thinking of converting the dynamic columns to static, then provide validations and again convert them to dynamic and update the table.
Advise me if my approach was wrong.
Regards,
Rashmitha