Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
borrisbeck
Contributor
Contributor

Length in schema - Irrelevant?

when tried reading records from both delimited files or database, the "length" of the records specified in schema seems irrelevant, whatever the length specified talend still reads the whole record? why is it so?

Labels (2)
2 Replies
TRF
Champion II
Champion II

Hi,
These informations are used when using tXxxDBOutput components to fix column lenth when the output to tables are create by the components. Also used by tSchemaComplianceCheck to check the data complience with field definition when the option "Use another schema for compliance check" is activate.
Anonymous
Not applicable

As I understand it, for numbers Length is the total number of digits and Precision is the number of digits after the decimal point.  Usually numbers have a precision and scale where precision is the total number of digits and scale is the number of digits after the decimal point.  Talend instead labels those Length and Precision respectively for numbers.  Don't know why they seem irrelevant in your scenario.