DSXchange

Hi All, Oracle stage(OCI stage ) does not support Reference output link but supports Reference input link :?: Is thsi true statement ????? i thought Server jobs only use Hashed file stage as reference . even if we want reference data from oracle we can achieve this by using Hashed file stage interme...

Raji ,

Let us know more about your source & targets

Can you tell us what exactly are you doing using aggregate stage ?

did you try running this job with small dataset ?




paddu

we have different Oracle Source Systems NLS_LANGUAGE NLS_TERRITORY NLS_CHARACTERSET Source 1 :AMERICAN, AMERICA,UTF8 Source 2:AMERICAN, AMERICA ,WE8ISO8859P1 Source 3:AMERICAN, AMERICA ,US7ASCII Oracle Target:AMERICAN, AMERICA ,UTF8 Datastage 7.5x2 is set up to MS1252. We have SAP/BW intermediate to...

Sorry Ray ,

i am late .Got stuck in a meeting .

Wonderful Information .ThankYou Very much.

:D

Thanks
Paddu

yes you are right, In our project we had 7.5x2 but we did not develop any parallel jobs so we got back to 7.5.2 version now in only Dev Box . IBM customer service told that we should not have the Abnormal Termination & Exception raised in GCI subroutine problems with 7.5.2 ( current release marc...

Thanks I_Server_Whale

I appreciate your input.

I am confused with the verions 7.5x2 and 7.5.2 , which released earlier ?

It woudl be really great to know about all other versions also.

Hi All,


CAn i get information on the datastage earlier versions .
I tried to search this forum but did not find or may be i did not do a proper search.

I want to know the versions in the chronological order .

It would be a great help.

Thanks
Paddu

Yes . i need to do that .

I gave NOT(IsNull(col1)) or NOT(IsNull(col2)) in Transformer constraint and it did not pick this record.

I_Server_Whale -I just used Char length 3 in sample job . Note :Below is what happening in the Original job Ray - Below is the value I see when i open the source file . We get zipped files from mainframe and then we unzip them . we got a small file this time . i opened in textpad and see only the ch...

Hashed files are default Type30(dynamic).

Nothing Unusual in Output Stage.

Did anyone try replicating my situation in their envirnoment ?

Please let me know ,if you did face situation similar to me or its only me having this sitaution.

Hello Ray, The version we have is Datastage 7.5x2 on Windows2003 server and client windows 2002. We designed the project in Server jobs only. It seems my team had issues with Parallel jobs and they ended up using Server jobs only . Unfortunately i cannot provide couple of source records.The file is ...

NO Source file does not have "?" Ofcource Source file has a blank record. The fields could have zero length string or space or Nulls in it .No idea .We did not check that ,May be it had zero length string and that's why hashed file picked that record as Ray mentioned . Sorry ALL for asking...

I am seeing "?" mark in the flat file which i am populating using the Hashed file .basically Job2 which i mentioned in my earlier post.

Hi Ray, Extremely sorry for "Hash file" :oops: . i truly did not understand the below "It may also be that the "?" characters are an artifact of the tool that you are using to view the data. How are you viewing the data in the hashed file? " We have NLS MS1252 as Projec...

beaditya , get rid of the index on that particular field. If it is not a primary key and you had index on it then it is fine for you to remove the index on that particular column . If you have access to TOAD or other Oracle query tool you can do it . If not involve DBA to get rid of the index on col...