DSXchange

If you want all rows from your tables, try the following style query to produce your source dataset: select key, sum(METRIC_A), sum(METRIC_B), sum(METRIC_C), sum(METRIC_D) from ( select key, metric "METRIC_A", 0 "METRIC_B", 0 "METRIC_C", 0 "METRIC_D" from table_A union all select key, 0 "METRIC_A", ...

I will be out of the office starting 06/23/2003 and will not return until 06/30/2003. I will respond to your message when I return. =========================================================================== IMPORTANT NOTICE: This communication, including any attachment, contains information that ma...

Assuming all values of "Key" are represented in Table 1. If Tables 2 -> N have any unique Key values, they will be left behind. (Unless this is what Ray meant by "fixed for all possible key values") Otherwise... perhaps a job that reads a single Table X and writes to Metric_X in the final table? It ...

If N is known in advance, and is fixed for all possible key values, then you can construct a job that takes its stream input from Table 1, with reference inputs from each of Tables 2 through N supplying the values for the other non-key columns in the target table. ----- Original Message ----- From: ...

Hello all, I have several tables with the following structure: Table n _______ Key Metric_n and I want to produce only one table with the following structure: Final Table _________ Key Metric_1 Metric_2 Metric_3 Metric_... Metric_n What are the approaches I can use to do that? Thanks in advance. Nun...

See response at m ----- Original Message ----- From: "Babatunde.Ebohon" Date: Mon, 23 Jun 2003 09:18:11 -0500 To: Subject: Server Job lookup > Does anyone knows how to perform a lookup in a server job? > > Tunde > > > -- __________________________________________________________ Sign-up for your own...

Tunde You need to do the tutorial. If you draw 2 links to a transformer then the second inbound link is a lookup. Thanks Kim. Kim Duke DwNav - Navigate ETL Business Rules www.Duke-Consulting.com -----Original Message----- From: Babatunde.Ebohon [mailto:Babatunde.Ebohon@target.com] Sent: Monday, June...

Does anyone knows how to perform a lookup in a server job?

Tunde

Hi all, IS SOME ONE CAME THRU THE ERROR (40503) A CALL TO AN OLE SERVER HAS FAILED OR A RUNTIME ERROR OCCURRED WITH IN OLE SERVER ITSELF when i open again the server it is ok,is there any one encountered this
error,what is the best solution thanking all Linga

Mightve been nice (for backups) if youdve been able to keep SUSPEND.FILES (imho, but tough for 24x7). -- __________________________________________________________ Sign-up for your own FREE Personalized E-mail at Mail.com m CareerBuilder.com has over 400,000 jobs. Be smarter about your job search m

Steve Glenn is correct it is sort of Universe now but the user does not really see a difference. If you are on UNIX then there is a script in the /etc/rc2.d usually which will start or stop DataStage very cleanly. It is documented in the manuals on how to do this. The script will remove all attached...

I know this is kind of mincing words here, but DataStage "used to" sit on top of UniVerse. By "used to", I mean as Ardent or Informix, the DataStage product "was" on top of Universe, but now that the company is Ascential, the product sits on top of something we internally call DSEngine. This is beca...

Hi Kim, Is there a way to stop new users from connecting via odbc when you want to shut down the engine? or is there a way to terminate users cleanly before an engine shut down? Steve -----Original Message----- From: Kim Duke [mailto:Kim_G_Duke@Yahoo.com] Sent: 19 June 2003 18:05 To: datastage-users...

Hi Kim, Thanks for your help I will pass your information on to my manager. Thanks again steve -----Original Message----- From: Kim Duke [mailto:Kim_G_Duke@Yahoo.com] Sent: 19 June 2003 18:05 To: datastage-users@oliver.com Subject: RE: Backups and Restores corrupting Dstage jobs Steve DataStage sets...

Looks to me like something has changed in TNSNAMES.ORA or perhaps the type of name resolution has changed in SQLNET.ORA, in both cases on your DataStage server. Do you have more than one Oracle Home (eg for multiple versions of Oracle) on your DataStage server? Ran into one site that had this proble...