DSXchange

Hi all, I have received XML file from the source system which is stored as a clob in the db2 table. Now I have data like this in my xml file. <Object name="Person"><Attribute name="Name"><Scalar>david</Scalar></Attribute><Attribute name="erfestival" type="String&qu...

I want to fetch the updated records from a sequential file without using changecapture. How to perform this.

Plz give me some solutions.

Hi I have table with processId CustId 1 z101 2 z101 3 z102 4 z103 1 z103 I want for each custId ---- corresponding ProcessIds should be taken. Ex: for z101----- ProcessIds are 1,2 I have further codings with that each processId values. this something like a nested for loop in C Coding For(..) { for(...

" You don't specify what needs to happen if all the fields are the same except for date, and two records (or more) have the date populated with different values." Yeah.. you are right. If all the fileds are same except for date then those two records need to be populated. Source Id seq typ...

Hi, I need a help in doing this logic. I have a source table as follows. Id seq type date 101 564 'A' 29/06/2007 101 564 'A' null 102 432 'D' null 102 784 'D' null 102 894 'C' 07/04/2008 I want the output as Id Seq type date 101 564 'A' 29/06/2007 102 432 'D' null 102 784 'D' null 102 894 'C' 07/04/...

Thanks to all. My problem is resolved

YearFromDate function is not working. When i compiled the job, i got error like this

Error in output column derivation expression for column Dat_BE_D in link LkOutTo_RM. Invalid conversion requested from a dfloat to a date.

I have to calculate the date of 365 days from today's date.
It means current date - 365. How to do this in data stage?

Hi,

How to reduce one year from the current date. I already tried with DateFromDaysSince. But this logic does not work. Can anyone have other approach for this? Please help me to resolve this issue

Hi, My source is DB2. When I load the data into the Char field (6) in to target table, the data is getting loaded with spaces. I have tried with trim option also. But it does not work. EX: This is my job flow DB2---->Transformer-->DB2; Source Target RMTYPE_ C RMTYPE_C MUL MUL  SEQ SEQ Please h...

Hi All

I want to create surrogate key based on my natural key for my job at UNIX script level.I don't know how to create at script level.plz help me to resolve this issue.
EX:

Code S.key
000T01 1
000T02 2
000T03 3
000T04 4

Hello, My job design dataset -> removeduplicate-> lookup -> database In this job i am trying to load data to dimension table in sybase db. when i am loading 100 records its inserting fine. But i need to insert 8 million records. when i am loading 8 million records i am getting follwoing fatal error ...

Hello, My job design is dataset ->aggregator -> transformer -> dataset i am doing some aggregation in this job. when i run this job with sample data its running fine. But when i run with 10 million data i am getting following memory error "Operator Terminated abnormally. Terminating with except...

I am doing in datastage only. My source is dataset which is having 6 records where key column is Key_Pln_N and my reference table is db2 which is having 29 records where key column is key_pln_n1. I want compare the records between these two columns. if records are unmatched between these two columns...

Hi, I have two columns in my source table Key_Pln_N and key_pln and my reference table column is key_pln_n1. now, i want to compare with key_pln_n1 and Key_Pln_N. If there is any unmatched records between these two columns i have to populate those records in to my dataset. Plz help me to resolve thi...