Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

PowerMart/PowerCenter column limitations?

Status
Not open for further replies.

DebbieKat

Programmer
Aug 8, 2001
14
US
We have several tables that are quite large (over 100 columns). Does anyone know if Informatica has a limitation on number of columns? Or is this totally just dependent on the database being connected to?

Thanks!
 
DebbieKat

We have been using Informatica Powermart 5.1 with Oracle 8.1.7 successfully with over 400 fields in one mapping. Apart from being slow, this has caused one significant problem - the debugger will not work. We found that this wasn't a show stopper, but given the complexity of the mapping, it was very difficult to debug - so it required a very good test team to throw the right data at the mapping, so we could isolate problems in the logic as and when it occurred.

Hope this helps

regards

Mark
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top