Page 1 of 1
transformer
Posted: Fri Jun 17, 2005 1:02 pm
by chalasaniamith
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
Posted: Fri Jun 17, 2005 1:23 pm
by pnchowdary
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.
thanks
Posted: Fri Jun 17, 2005 1:44 pm
by chalasaniamith
tnx for taht
Posted: Fri Jun 17, 2005 2:52 pm
by satish_valavala
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.
hi
Posted: Fri Jun 17, 2005 3:16 pm
by chalasaniamith
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
Posted: Fri Jun 17, 2005 5:17 pm
by ray.wurlod
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.
hi
Posted: Sat Jun 18, 2005 6:56 am
by chalasaniamith
hi ray
thanks a lot...