You are not logged in.

Refresh field structure in relational extract

Dear visitor, welcome to Palo Community Forum. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

konradmai

Master

  • "konradmai" is male
  • "konradmai" started this thread

Posts: 54

Date of registration: Apr 18th 2007

  • Send private message

1

Monday, August 6th 2012, 5:21pm

Refresh field structure in relational extract

Is it necessary to refresh the field structure in the relational extract? And what is it good for? Can I omit this step?
I'm asking because it takes a very long time. It's running for more than 1 hour now and it is still not finished. It always depands on the complexity of the SQL statement.

BR,
Konrad

tish1

Sage

Posts: 762

Date of registration: Jul 13th 2009

Location: Vienna / Austria

Occupation: Senior Consultant @ Vector SW DV GmbH

  • Send private message

2

Tuesday, August 7th 2012, 1:47pm

Hi,

in relational queries I hardly ever use this feature.
It's helpful, when working with files, because you can rename column there and set default values for null values.

Regards.
Robert Tischler
Senior Consultant Vector SW DV GmbH

This post has been edited 1 times, last edit by "tish1" (Aug 8th 2012, 8:51pm)

konradmai

Master

  • "konradmai" is male
  • "konradmai" started this thread

Posts: 54

Date of registration: Apr 18th 2007

  • Send private message

3

Tuesday, August 7th 2012, 2:22pm

Thanks for this info. Normally I also use this. But it doesn't seem to be necessary to execute this step.
Yesterday I killed this job after several hours running.

BR,
Konrad

a_froehlich

Sage

Posts: 173

Date of registration: Jan 4th 2008

Location: Freiburg / Germany

  • Send private message

4

Thursday, August 30th 2012, 9:57am

You only need this to change column names and/or set default values in the Relational/File Extract. Otherwise it's not necessary.
I wonder that it takes so long....

konradmai

Master

  • "konradmai" is male
  • "konradmai" started this thread

Posts: 54

Date of registration: Apr 18th 2007

  • Send private message

5

Thursday, August 30th 2012, 11:20am

Quoted

I wonder that it takes so long....
It seems that it takes as long as the underlying SQL statement takes. And this is quite long.

Similar threads

Rate this thread