Page 1 of 1
Maximum Number of Column in all Stages
Posted: Thu Jul 08, 2010 12:04 pm
by laknar
Anyone have the document on Column limitations in Datastge.
We have a requirement where we need to load thousands of columns.
Posted: Thu Jul 08, 2010 12:22 pm
by anbu
Posted: Thu Jul 08, 2010 1:47 pm
by laknar
Does Ray mean. We can have unlimited columns in all stages.
But the limitation is only on OS and Database Side.
Posted: Thu Jul 08, 2010 1:54 pm
by anbu
Yes there is no limit for columns in DataStage
Posted: Thu Jul 08, 2010 4:56 pm
by ray.wurlod
That is true, however the underlying operating system in the engine may impose a limit on the amount of memory that is available and/or on the maximum width of a line in a file, either of which could thwart your evil plan to process 20,000 columns.