DSXchange

Hi All, I am using DS 8.1 version. I am facing some problem when I am trying to read multiple record formats by CFF stage. I have got 1 huge copybook through which I am able to import the metadata successfully. All records are fixed width having length of 1000 bytes. I have separated these records i...

Hi,

I am trying to abort the job on the basis of 1 condition. If that condition is not satisfied, the job should get aborted.

EX: If 'SQLcode' column value is not equal to 0 then job should get aborted.

Can anyone suggest the solution for this??

Hi

I want to do null handling using Modify stage rather than transformer stage.I am using following function.

DEF= Handle_Null (DEF,'AAAA')

DEF is the column name.
But rather than transferring null as AAAA, it is transferring null only.

Can you please give me some solution?

Hi I am also facing same problem. I want to do null handling using Modify stage rather than transformer stage.I am using following function. DEF= Handle_Null (DEF,'AAAA') DEF is the column name. But rather than transferring null as AAAA, it is transferring null only. Can you please give me some solu...

Hi I am also facing same problem. I want to do null handling using Modify stage rather than transformer stage.I am using following function. DEF= Handle_Null (DEF,'AAAA') DEF is the column name. But rather than transferring null as AAAA, it is transferring null only. Can you please give me some solu...

Hi all, I am facing a problem in which I have data in a sequential file in 5 rows. In that I want all the 1st rows' data to come as column names. Can anybody tell me how to convert rows into columns. DATA IS AS: Name value column1 10 column2 20 column3 30 column4 40 column5 50 And I want the data as...

Not sure I understand you. Are you trying to expire a dimension row? You would need to close out the existing dimension row setting end date to current date. You then need to decide whether to leav ... Hello, I have done the same thing. Iam trying to expire a dimension row with the current date. Bu...

There is a presentation on the SCD stage at the LeverageInformation site. The link is in my blog post [url=http://blogs.ittoolbox.com/bi/websphere/archives/7-even-better-online-datastage-tutorials-20 ... Hello, I used all the steps given in that presentation about SCD. But rather than updating a ro...

Thanks a lot Sir.
It will help me a lot.

Hi, Currently i am working on SCD stage in DS 8.0. But I am facing the problems of setting the purpose codes. I want to implement the Type 2 SCD. The purpose code 'Expiration date' can have the Expires derivation but I am not getting the correct method to specify it. Has anyone implemented this befo...

yes, there is no manager in DS 8.0.
But i didn't get the option for Usage Analysis in DS 8.0 designer.
I also searched in DS 8.0 documents but didnt get it..

How would I find DS job names from the table name in DS 8.0?
It is possible in DS 7.5.1 using usage analysis..