Extract dynamic fields in job

One Star

Extract dynamic fields in job

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
One Star

Re: Extract dynamic fields in job

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

Re: Extract dynamic fields in job

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

Re: Extract dynamic fields in job

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
One Star

Re: Extract dynamic fields in job

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