DSXchange

Hi, I have 100+ Jobs in my project. If i want to debug for a particular record then iam scanning each and individual job to see where the record got dropped exactly. If iam the developer of those 100 Jobs then i can identify the exact job with some assumption since i know the business requirement. B...

Hi All, My requirement is as below...... First get a record from Table A and then get the record from Table B and do the runn_bal - rem_amt. If runn_bal - rem_amt <> 0 then update the runn_bal with runn_bal - rem_amt an Table A , and get the second record from Table B and and do the math again...an...

Hi, I am facing one issue in Datastage. I need to create a Seq file containing different date values like start date, end date of a month and couple of more dates. I have different kind of jobs, generating from Query and writing to a Seq file, getting a row generator as input and writing into a Seq ...

Hi Ray, I have to handle this LIKE operation between two different datasets. i.e) from the extract Query i will handle some logical functions in Data stage and load into a dataset. Then from two different streams(Dataset1 & Dataset2) i need to handle this LIKE operation. Can u pls guide me. Than...

Hi, In one of my existing Jobs, we are using a SQL query to fetch records from different tables. One of the Join condition used is LIKE option between two columns from two different tables. Now i have to extract the records simply using the table and need to handle the logic & join function in D...

Thanks Ray.

Thanks Ray. But lets say, if i have 2-3 join stages and much more stages which requires sorted records then i have to use explicit sort stages and also if i have multiple jobs which have schedhuled at the same time, which has more explicit sort stages then how this resource disk will handle that. Wi...

Hi, I am sorting the input record for Join/CDC stages. But if i give implicit sort iam getting an warning "does not not fulfill sort requirement", but if i use Explicit sort, iam not getting any warnings. Which way is advisable, implicit or Explicit. What is the advantage/disadvantage amon...

Thanks Ray.

Hi Ray, Nullability is working now, the change made is, the data type for the columns coming from the right link is changed to YES. But why we need to define it in the input link to the join stage itself. All my records in both the input links are Non nullability records and giving to the Left Outer...

Thank You ray, but we dont have hex editor installed in our machine. Will try for that asap, but now all i have to do is, i need to fix this issue in data stage for which i need support from people over here.
Thanks.

Hi, You have to clear the previous partitioning before giving it to a new partition. In the second join which is on key2, you should clear the previous partiton which is out of key1. Also the next consecutive joins is also based on key2 alone, if so then use same partition else clear in 3rd join and...

Space and ASCII are two different characters having different ASCII values to each. For the unmatched records the value usually datastage will give as "NULL".. I totally agreed to ur point, but why the non hit output record is giving some junk values instead of NULL. How to handle this si...

Hi, Iam using Join/Lookup stage in one of my Jobs. Two Input datasets performs Left Outer Join, when there is no hit then the columns from right dataset should give a empty space or NULL(Data type is Char/varchar). What is the difference between "Space" and NULL. I have used Null function ...

Can you give us more details? Which stages you are using and how you are making 2 records of one record ? There is no rule as such there should be same number of input and same number if output..otherwise row generater might not have worked at all :wink: Actualy Im using 3 stages in the job: input ...