DSXchange

Hi All,

I have the sequential file with the Values as

Kumar[NUL][NUL]
Bala[NUL][NUL]

In a single column, I need to remove the [NUL] values from it and lkp with reference data. your help will be highly appreciated.

thanks vivek.

I need to abort my job if my Col1<>col2, please let me know if you have any thoughts?

Hi All, I need to abort a job if my Credit=Debit values are not equal. Can i do this in transformer stage? I am using Version 8.

Thanks for that, Stilll I am wondering to differentiate between Advantages of Transformer stage in version 8 with Filter and Switch stage.

Hi All, In my project we have million's data to filter out based on condition. could you please suggest me which is the best stage to use, Performance wise should be efficient. Transformer/Fillter/Switch. Thanks in advance.

Hi All, I am trying to install datastage Version8 in my local system. After selecting all the option required in screen's it started intalling DB2 Database which is an part of the intallation kid. After the 5% it shows an below error and revers the installation. "EroporotoryInstaller65514. An e...

Hi I am getting the following error when I try to Install the Datastage 8 server in my system. "The user xmeta exist in the system with a different or expired password, the user account is diabled, or the user doesnt have permission to access this machine from network. verify the password and u...

Hi,

I know that in a 32 bit we cant write more than 2GB to a file, I want to know what is the 64 bit file size limit?

In my current project I am able to write more than 34 GB to a sequential file and a dataset. I am wondering what is the 64 Bit file size limit?

Regards
N.Magesh

Hi,

I think you need to use the same file as right and left. then you can achive the self join in datastage.

I am sry, If am asking the same question again. I need to gzip the Sequential files, When I use the Compress stage I am getting an error "Error when checking operator: Could not find input field "FT_ACCOUNT_KEY". How do i overcome this problem? In my Input I have 21 column what should...

How can I gzip the Sequential files using Datastage, Do we have any stage to do?

Hi All,
Can I use the COmpress stage for Sequential file? If yes please let me know what should be the Output columns for it?

Thanks
Magesh

I was trying to load the huge data from my source system into the Oracle table, It got aborted due to the Table index problem "Unusable" status. So they have enabled the below option "OPTIONS(DIRECT=FALSE,PARALLEL=TRUE,SKIP_INDEX_MAINTENANCE=TRUE,SKIP_UNUSABLE_INDEXES=TRUE)" Plea...

I have enabled the below options
OPTIONS(DIRECT=FALSE,PARALLEL=TRUE,SKIP_INDEX_MAINTENANCE=TRUE,SKIP_UNUSABLE_INDEXES=TRUE)

Please let me know the Right options to use? Your help will be highly appreciated.