I have a requirement where I need to make the SQL query as dynamic. So, I have designed the job in such a way that for SQL query I have made it as context and for schema, I have defined a single column and made the type as "Dynamic".
I am writing the output to tFileOutputExcel. I need to understand if there is any limitations in using "Dynamic" schema and in final excel file will there be any data change w.r.t what we retrieve using same query from Database.
Hello, You can use a context variable for SQL and a Dynamic schema, and Talend will adjust automatically. No - Talend Dynamic does NOT modify data values. It passes the exact row values returned by the database. Only differences you might see: Formatting changes (e.g., timestamp appears as string in Excel) Excel may auto-format numbers (e.g., long integers turned into scientific notation) Very long texts may get truncated in Excel due to Excel cell limit (~32,767 chars) But the data content itself is identical to the DB query output.
