Maximum Number of Column in all Stages

laknar · Post by **laknar** » Thu Jul 08, 2010 12:04 pm

Anyone have the document on Column limitations in Datastge.
We have a requirement where we need to load thousands of columns.

anbu · Post by **anbu** » Thu Jul 08, 2010 12:22 pm

Check this link
http://dsxchange.com/viewtopic.php?p=36 ... b43#369093

laknar · Post by **laknar** » Thu Jul 08, 2010 1:47 pm

Does Ray mean. We can have unlimited columns in all stages.
But the limitation is only on OS and Database Side.

anbu · Post by **anbu** » Thu Jul 08, 2010 1:54 pm

Yes there is no limit for columns in DataStage

ray.wurlod · Post by **ray.wurlod** » Thu Jul 08, 2010 4:56 pm

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.