DSXchange

Hi,

When I assign an 'Operator' role to a linux USER group and I am loging in with this profile I stil have Developer privileges, I can save and change jobs.
Can you help with some suggestions.

Thank you,

Florin

Hi Ken, Yes, is a new database. I am using the ODBC driver provided by HP Neoview. These are my entries in uvodbc.config ( both) ... <HPODBC> DBMSTYPE = ODBC network = TCP/IP service = ods host = 172.99.99.99,18650 ...and .odbc.ini [HPODBC] Driver=/usr/lib/libhpodbc.so Description=FRY Neoview ODBC P...

Hi, I am connecting, through ODBC, to a HP Neoview box and I am getting this error message. It seems that the metadata that DataStage is trying to fetch is too long, but it shouldn't be. Any ideea how to solve this issue? Thank you, Florin DSR.MetaGeta(GET.TABLES)(SQLFetch): BCI Error: SQLSTATE=0100...

It looked like that you pointed to 64-bit library. I have changed to /usr/bin/g++32...and less errors. Output from transformer compilation follows: ##I TFCN 000001 17:07:53(000) <main_program> IBM DataStage(tm) Parallel Extender 7.5.3 Copyright (c) 2004, 1997-2004 Ascential Software Corporation. Al...

Hi, We have installed DS EE 7.5.3 on a Red Hat Linux AS version 4. Problem Description. The c++ compiler doesn't seem to work. APT_COMPILER and APT_LINKER are set to: /usr/bin/g++, based on... -sh-3.00$ which gcc /usr/bin/gcc -sh-3.00$ which g++ /usr/bin/g++ I am trying to compile the simplest job t...

Thank you, Ray. I might get five pounds back.

Thank you Th...but I just lost ten pounds. I bet on "good practice".

Best Regards,

Ovidiu

I will try join stage...you are right.

Thanks,

Ovidiu

The big table has two fields: A_SurrogateKey, A_ID .
In the stream data I have 3 fields B_ID, C_ID, D_ID . All of them are looking up A_ID in order to get A_SurrogateKey.

Thanks,
Ovidiu

Thanks for your suggestion Ray,

I don't know if I can solve the problem with only one Merge Stage...since the master link should be the stream data ( I need also the rejects). In this case I have three master links (for B, C and D key fields).

Thank you,

Ovidiu

Hi everybody, I have a big dimension ( 5.000.000 rows)(2 fields: A_SurrogateKey, A_ID) that I have to lookup to get foreign keys for 3 fields( B_ID, C_ID, D_ID) from the stream data (300.000 rows). The lookup keys are (A_ID, B_ID), (A_ID, B_ID), (A_ID, C_ID). I am looking for the best solution. Spar...

Thank you very much

Florin

Hi everybody, I need to design a sequence that triggers three jobs-A,B,C-. The sequence is executed multiple times a day. I need one of the jobs- A -to be executed only once per day. So for the first time all A,B,C jobs and after that within the same day only B and C. Thank you for any advice. Ovidiu

Oracle Enterprise Stage Properties:
Write Method: Load
Write Mode: Truncate

Options
Disable Constrains=False

Index Mode=Rebuild
add compute statistics=true
add nologging=true

drop columns not in table=false
truncate column names=false

Thank you,

Ovidiu

Thanks for the answers...I just found a string date to relate to ...but is good to know.
Thanks again