DSXchange

"By stating the reference link has multiple rows does remove the duplicate reporting" ... You achieve that by selecting the reference link in the property "Multiple Rows returned from Link" , right? I tried that and warning is removed in my case too .. and strangely I have not en...

The warning is thrown because we have duplicates in reference link for "Col1". I have also faced the same problem, and as a workaround, I have made an inner join of the two links, thereafter filtering them on the condition

Timestamp >= StartTS and Timestamp <= EndTS.

u can merge them using FUNNEL Stage.

the desired output could be achieved by following logic implemented in transformer stage stage variables written in following order - SVarDate (varchar8 ) --> decimaltostring(CCNPOD,"suppress_zero") SVarCounter (varchar 2) --> decimaltostring(CCMPMO,"suppress_zero") SVarMonth (va...

What is the partitioning done on the Oracle Enterprise Stage?

If you have used RoundRobin, could you try with Hash/sort on Target Table Key Columns.

Could u set the field default properties as given below -

Delimeter = comma
Quote = none

and then check..

Hi Brad We are doing exactly as the last point of your's (providing enough natural keys and record types), but we are facing an issue due to the presence of "packed decimal" values in the raw field of some record type. Could you please suggest, if there is any property in Column Import sta...

You can achieve the result by using the following stage variables - decimaltostring(<column_name>,"suppress_zero") ............. SVar1 Index(SVar1, ".",1) ............. SVar2 Len(SVar1) - SVar2 ............ SVar3 And then writing the following derivation - SVar1[1,(SVar2- 1)] : S...

Can you try to trim the input field first and then check with IsNull() function as shown below -
IsNull(Left(Trim(input_column_name),Len(Trim(input_column_name))))

you can use the following derivation in transformer......... considering the input column name as tempdate.......

tempdate[1,6]:'19':tempdate[7,2]

but the question here is how to decide about the century?? i have hardcoded that here as 19 but it can be 20 also......

Can u store all the keywords in a sequential file? If yes, then u can write a Job Control (In a server job)... wherein u will traverse the sequential file in a loop (taking one keyword at each time) and storing it in the seesion. Then, u can call a parallal job from the job control, which has in its...

have u tried trimming using the function -

Left(Trim(col_name),Len(Trim(col_name)))

The transformer should be executed in the sequential mode, to achieve the desired output.

vkhandel, The trim function which you have posted worked. But i was wondering why isn't the normal Trim not working . Thanks! The reason which i understood is that the field is appended with a null character at the end '\0' instead of spaces... thats why the trim function is not able to truncate th...

I already have a transformer between Db2 stage and a CDC stage,where in i am trimming the varchar fields. But still there is problem. Thanks Try to trim with the following function - Left(Trim(col_name),Len(Trim(col_name))) I have faced the problem, wherein trim was not working properly for the fie...