DSXchange

For one of my field in the target i'm doing Null handling. I used this function for handling null "NullToValue()". For e.g: OP.Col1 --> NullToValue(IP.Col1,' ') And this field i'm mapping to sequential file stage and a dataset stage. The job ran successfully but when i'm viewing the data f...

I have requirement where i need to compare two dates say ReportDate and StartDate. I'm comparing thie two dates in a filter stage as "ReportDate > StartDate". StartDate is present in the input dataset of format yyyy-mm-dd and ReportDate is a parameter for which the value i'm giving as '200...

Thanks for your inputs..

I'll go with transformer stage..

Can we able to use nested functions in modify stage?

For e.g:- All the columns Xid,Yid and Zid are of same datatype.
Xid = handle_null(Zid,handle_null(Yid,Xid))

Please help me out...

Could anyone please provide pointers to this..

I will be grateful to you people...

Thanks Ray for your response..

The Service will take around 5 to 10 sec. At max it takes around 10 sec.

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 have a requirement where i have to call web service to get the table information by passing table name as a parameter to it, through datastage. The response received from the service should be loaded into a sequential file. Could anyone please tell me the things which i need to complete for the ab...

Thanks Ray for your response..

3) I came to know from my colleague... just want to confirm with the DS Experts before accepting that..

Could you please let me know the best feasible design for Scenario 3..


Thanks..

1) I have requirement where i have to join with some tables and views. For a Job atmost we're using 5 join stages and 10 sort stages( since the pre-requirement for join stage is to sort the data). Since i have 5 join stages with two inputs, for each input one sort stage so total will be 10 sort stag...

Thanks Ray..

Thanks Mike for your instant response... I got the output without any warning...

Could you please tell me why in warning message datastage mentions about the date_from_string function though i'm using StringToDate() function?


Thanks..

Thanks Mike for your instant response... I got the output without any warning...

Could you please tell me why in warning message datastage mentions about the date_from_string function though i'm using StringToDate() function?


Thanks..

I have a date field from input as Start_Date(8) which has Nullabilty as "Yes".My requirement is to check whether the field is Null, if null then it should be replace with 00000000.This field is mapped to the target field Charge_Date(8) in the target dataset. In the output derivation of the...

I used oracle enterprise stage to read the data from a view. I selected the option as Read method--> table and under table name i given as vw_assets (which is a view).When i am trying to view the data it's giving error as "APT_OracleRowid8PartTable: Failed to get the block count" and "...