DSXchange

Hi,

While I import the Oracle Metadata structure from Database, it importing but its not importing with length/size of the column.

anyone pls help me.

Thanks in advance.

If hard coding is working and the parameters are not working means there are some issues with parameters only.. 1.Check your parameters properly. 2.Check if there is any space of path name which you are passing is correct. Hope this helps. Parameters are correct and there is no space. If i pass the...

Hi all, I have created a server job which has desing as below. Seq.File -----> Transformer --------> Oracle stage It successfully completed. I have created a copy of the above job and the file metadata structure is same and used Parameter for Pathname and Filename. when I check to view the data, its...

Hi all,

I'm not able to import the table metadata from oracle 10.2.0.2 database. As it showing the below error message.

"Unable to initialize plug-in:"

Could somebody help me out.

Ray,

I have cleared the Client Session from Information Server.

But also it is not allowing to login.

Hi all,

I was working with DS 8.0.1 version, in between connection broken and I closed the window and tried to re-login but i am not able to login.

I am not getting any error message also. the cursor showing in processing state.

Could anyone help me?

Thanks in advance.

ray.wurlod wrote:Good, it's a supported operating system. But our previous answers are unchanged.

Its very much useful and informative. Thanks experts...

The Operating System we use is "Red Hat Enterprise Linux AS release 4 (Nahant Update 4)" is same for both the versions.

Ray,

Moved means export from one environment and import into the new environment but here the codes in different version.

Is this possible to export/import the code from lower to higher version? If so, could you please tell me how we can achieve.

Hi all,

Could anyone help me whether the project which is created in DS 7.5.1a version can be moved to DS 8.0 Version.

Thanks in Advance.

Based on the transformation table EXPRESSION column, I need to perform the conditions with the source table. I dont understand, how Datastage will pick the EXPRESSION column values as conditions and perform according to that. And through UI, those EXPRESSION Column conditions may change in period of...

Hi all, I have a source table which have column CUST_SEG_CODE and another column TGT_CODE. I have another table which have the rules for transformation. The structure is as like below. Rulegrpcode Baseval Expression TGT_CODE ExecSeqNo PSCUSTCLAS 98 IF(CUSTSEGMTCODE=98 ) AND (ACCLASS=611101) 101 1 PS...

Hi all,

I have used the Array size = 32767 and Transaction size = 20000. And aslo prefetch memory setting = 20000. Could anyone help me whether this combination is correct one or not?

Thanks in advance.

Hi,

Please find the below error message which i got from one of the datastage job. Help me. Could some one tell me, what would be the root cause for this error?

J_Strip_Funding..Hashed_File_31.IDENT4: ORA-01555: snapshot too old: rollback segment number 3 with name "_SYSSMU3$" too small

hi all,

Please tell me how to compile the data stage jobs in unix box command line. Thanks in advance..