DSXchange

We are using Oracle read parallesim in datastage to run the same query on multiple nodes..Later we have to sort the data to remove dups.Is it better perform if we do Oracle Sort and Again Datastage Sort or just do datastage Sort? If the data is sorted in oracle before it goes to Datastage Sort,Is da...

Hello, I want to know where do we use Sparse Lookup exactly. We are using Joins right now and want to replace with Sparse if the rows from Input are less compared to Lookup dataset. I dont know the exact ratio between Input/Reference. Is the sparse lookup good with 1 rows(input):20 rows(referenceLoo...

Is there a way to delete specific records from a dataset? I didnot want to delete whole dataset using orchadmin utility. any help is appreciated.

Hello,
I just want to know how the log files create for any job that we run through script or manually. It creates following way. How does it get 1286384 and 380289 in this log name ora.*.*.0.log. Please help me

LOG=ora.1286384.380289.0.log

I am trying to load an oracle table through datastage Enterprise. It uses SQL loader to load this table from a pipe generated control file. I have a field which is rejecting that record which is description, currently it is varchar2 (1000), the characters are no way near hitting 1000 characters, but...

thanks for good idea..that should work..i will try tomorrow and let you know..i really appreciate your help..i was doing complex query to get this way.more burden on database side...this new approach will perform better for sure..

ABCD is active from 2005 to 2009. user changed his mind and again changed to old value DEFT that will be active from 2009 to 9999. So it can be valid to have this way.

ABCD is active from 2005 to 2009. user changed his mind and again changed to old value DEFT that will be active from 2009 to 9999. So it can be valid to have this way.

All, I need your help on a design,here is the sample data of a file. I need to get the output as shown below. Not sure how to get this result. I could not find out a way to do it datastage. Can you please guide me? Source key,Field,Start_dt,End_Dt 1234,ABCD,1/1/2000,1/1/2001 1234,ABCD,1/1/2001,1/1/2...

I am stuck on a problem here.. I have a source table with year-month column along with other fields. I have to generate date data for given month of source table. Ex: 2004-03 in source table, i have to populate 2004-03-01,2004-03-02,....2004-03-30 etc. along with other columns. Can we implement this...

I have to validate credit card number whether it is mod 10 or not. Example: 123466(input)
2*1+2+2*3+4+2*6+6
2+2+6+4+12+6
2+2+6+4+(1+2)+6=23/10..is not a valid mod 10 check. i should throw an error.

Does any one has mod 10 check routine to validate any number?

I am getting this error in one parallel job. This job has one source table and one target table..no stage is in between them. I have turned on DUMP score..i am not getting any thing from dump message. I could not find out where the problem is. main_program: Could not check all operators because of p...

I am using informix XPS fast stage as source and target stages. I have given proper database name and servername,still it is failing with below error. I tried to connect same table with informix client stage,it did work. Problem is happening with Informix Enterprise stage. Do i need to configure som...

We are using Informix XPS 8.4 version. I agree that length is limited to 18.