Hi everyone. I'm brand new to Talend, and am struggling to do the following.
The purpose of the job I am creating is to take data from a source MSSQL database and put the results into a different target MSSQL database.
I have complex MSSQL (T-SQL) SELECT query with some complicated logic and joins. Rather than using a whole bunch of tDBInput components and attempting to create the correct JOIN logic and transformations in a tMap, what I would like is to use a resource .sql file, execute it, and have the resulting schema available to me in a tMap, so that I can map the results to an output table in a different database. Is this even possible?
i.e.
resource file (SQL file) >>> resulting schema available as input to a tMap >>> map to an output >>> output to target database
I have found varied threads in this community where people have asked similar questions, but none of the solutions have worked for me (some made no sense, or I didn't appear to have the option of the components mentioned).
but the best way is to use one query by file all file in a folder and add number in name to order them. destination file must be file name
the use tfileListe
or
one file with the list of sql file to run and the name of destination table
