Importing a 190 column table definition: How?

abc123 · Post by **abc123** » Thu Apr 22, 2010 5:46 am

How do I do it? Orchestrate Schema Definition is not working. When I click on the final Import button, it goes to hourglass and does nothing.

ray.wurlod · Post by **ray.wurlod** » Thu Apr 22, 2010 6:50 am

Wait.

chulett · Post by **chulett** » Thu Apr 22, 2010 6:52 am

Right, nothing magical about have 190 columns.

abc123 · Post by **abc123** » Thu Apr 22, 2010 6:56 am

It goes to hourglass and after a few seconds, the hourglass disappears. I waited for over 10 minutes but no import happens.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Apr 22, 2010 7:10 am

Maybe there is some popup waiting for your response.

Something like 'Table already imported. Do you want to overwrite ?'

abc123 · Post by **abc123** » Thu Apr 22, 2010 7:36 am

I thought so too. I did a Repository/Refresh and obviously the table wasn't there so I tried again. Same thing. This is probably a Datastage bug.

Has anybody done 190 column imports using Orchestrate before?

ljulienne · Post by **ljulienne** » Wed Sep 08, 2010 2:14 am

We have a table with 270 columns and there were no problem to import using Orchestrate. For information, it is using Oracle. Maybe limits depends Oci.