DSXchange

Yes I am passing the values as date:00:00:00.000

I am converting rows into columns so am using pivot stage. But while doing that am getting below warning for timestamp field. When I run the job without Pivot stage am not getting this warning. So it is something to do with Pivot stage. Can anyone give an advise as to how this warning could be resol...

Hi, We are using Change Capture stage to indentify whether a record is an insert or an update based on a key column(one key column) and multiple values(15 columns). I am not getting desired results as everytime records are going for updates. Not all records are going for updates but some records. I ...

Hi, We have a requirement to implement a recursive logic for example Key ParentKey 1 2 2 3 4 1 5 4 3 6 1 is the record i have but i need to get parent and its grand parent and its great grang parent.like this i have to go till i don't find any record. Can we implement the above logic using DS 8.7 . ...

Craig, yes, always we can go back to System Engineer on this requirement. But let me tell you the same kind of requirement was implemented using Java. There variables was used to store this col1 and col2 values( let me clarify here this col1 and col2 value will be same for that particular load) and ...

Target columns to be populated in given in the requirement document. As i said earlier first two columns does not have any join with other three. To make it clear. logic goes like this source Col1- query table A - load into target col1 source Col2-query table B-load into target col2 source Col3-Quer...

We have to load data from multiple tables(oracle is the db) but there is no join condition between these tables. Let me give you an example I have 5 columns that needs to loaded into a target table. But the first column (col1) does not have any join conditions between other 4 columns, col2 also does...

thank you,
But nulltoempty() is not working in 7.5 . stage variable is the only option?

I have four input column, a,b,c and d where in the output column is E i am doing the concatenation of a:b:c:d to give the output E. But my problem is even if any of the four input column is null the E column should concatenate other three fields and give the output . It should not be null. Only case...

there are no warnings in the job log.

In the source itself these three records are being ignored. and this is in between the records. its a dos file and contains ^M\n towords the end of each record.all three records are coming in newline.

There is a file with n rows but sequential source stage is only considering
n-3 rows--we are reading it as DOS file

yes it is oracle, but my question is whether we can implement this using datastage or not.

Hi, I wanted to know , how we can implement the job to retrieve the hierarchical data. The exampale would is as below lets say we have a table a and three columns id1,name,id2. I need to get the all the parents of id1. for ex: if i have the below values in id1 and id2 field id1 id2 1 2 2 3 3 4 4 5 5...

do we have a like function or similar type of function in Datastage 7.5 server edition. We have values A.12,A.12-1 but we might get other values in the future(like A.12-3). I am in need of some function which can take the values in this way(A.12%).