Dynamically reading Schema From a table

ShastriV — Sat, 16 Nov 2024 01:41:22 GMT

I have a requirement where i need to read schema of 7 Views from MSSQL dynamically and output all columns into csv Files. What is the best way to achieve this? Please suggest

Thanks

Re: Dynamically reading Schema From a table

manodwhb — Thu, 13 Aug 2020 01:38:32 GMT

@vineela shastri , first lets have details of view queries and data details.

1) using tfiexedflowinput lets have column like query and use tFlowtoIterate

2) from tFlowtoIterate connect to tDBinput and pass global variable of query in tDBinput

3) in tDBinput have single coulmn with dynamic data type and connect to tfileoutputdelimitted and you can have the file as against view from tfiexedflowinput

Thanks,

Manohar

topic Re: Dynamically reading Schema From a table in Talend Studio

Dynamically reading Schema From a table

Re: Dynamically reading Schema From a table