DSXchange

Thanks for the response.

Now I have one more question ...Is there any relation between the number of processes running and the performance of that job.

Max

Hi, I was going thru the online manual(Server Job Developers Guide) chapter 2 which speaks about the Performance tuning of Server Jobs. Actually it was speaking about the number of processes running in a Job. I mean when a job is executed. So according to it, in a job 1. PassiveStage -> Active Stage...

Hi I would like to know whether there is any repository having questions on general Datwarehousing concepts and architecture :?: ...I feel that if there is one...then becoming familiar with the DW concepts and taking a test wud let me know how well i have done my homework...i mean understanding...Si...

Hi

Check whether u have added these variables as job parameters, if you are going to use them as parameters for passing values

Max

Hi Ray I am trying say vertical pivoting(ID,Page)discussed above...So i created Page as a Multiple valued field...and I normalized on that field...And for the association also I gave Page...But I have one doubt Even If I create my UV table with "Page" as Multi valued...I see only the first...

[quote="ray.wurlod"]Probably the easiest is to run the data into a UV table, with the "Page" column defined as multi-valued, normalized on the Page column. Then use either the synthetic key @ASSOC_ROW to limit the values that you retrieve from the dynamically normalized table.[/q...

Actualy you can import the sequential file definiton...Jus right click on the table definitions in Repository tree and import...It will list all the diff types...select sequential file definition and proceed...Set the properties accordingly...like the delimiter and other things...I think it shud hel...

Thanx Ray...So far I have been thinking that if its Red then, it wont compile...thanx for the clarification

Regards
Max

As far as the routine is concerned there is no problem...The values are getting stored in the variables(@USER0,@USER1,@USER2) properly...how do I use the values in these variable IN MY JOB...ie how do I assign the value stored in the variable @USER0...coz as I said If I use @USER0 in the derivation ...

Hi Pals Few days back I was going thru a discussion in this forum about returning more than one value from a routine.I used to concatenate those value using a delimiter and use the Field function to get them. Ray had told about the usage of system variables @User0-@User4.So out of curiosity I tried ...