transformer

chalasaniamith · Post by **chalasaniamith** » Fri Jun 17, 2005 1:02 pm

HI
is there any limit for no of columns to be used in transformer for ex like 232 columns can we use that bmany or any limit?
thanks in advance

pnchowdary · Post by **pnchowdary** » Fri Jun 17, 2005 1:23 pm

Hi Amith,

I have personally used about 160 columns, I dont think that there is any limit to the number of columns, to the best of my knowledge. If there is any limit, maybe the Dsx Gurus will be able to tell us.

chalasaniamith · Post by **chalasaniamith** » Fri Jun 17, 2005 1:44 pm

tnx for taht

satish_valavala · Post by **satish_valavala** » Fri Jun 17, 2005 2:52 pm

I don't think so.
But if you pull all the unwanted columns into transformer, job process time will be increased. Its a performance bottle neck at ETL level.

chalasaniamith · Post by **chalasaniamith** » Fri Jun 17, 2005 3:16 pm

not like that those are the important i mean necessary ones i know time is taking a lot anyways have to do that one
appricate for that anyway

ray.wurlod · Post by **ray.wurlod** » Fri Jun 17, 2005 5:17 pm

There is no limit on the number of columns in a row in DataStage.

However, you may encounter limits elsewhere. For example, the default limit via ODBC is 400 (which can be overridden by MAXROWCOLS in uvodbc.config). The maximum number of columns supported by MS Access is 256. And so on.

chalasaniamith · Post by **chalasaniamith** » Sat Jun 18, 2005 6:56 am

hi ray
thanks a lot...