DSXchange

Hi, You can do it in transformer. Inside the transformer, input link sort and partitioned on key. Define two stage variable, count (number) and IDS varchar. Append ID in IDS based on key and create output link with these two additional field. Next stage is remove duplicate with SAME partitioning met...

Hi, You can do it in transformer. Inside the transformer, input link sort and partitioned on key. Define two stage variable, count (number) and IDS varchar. Append ID in IDS based on key and create output link with these two additional field. Next stage is remove duplicate with SAME partitioning met...

Hi,

Use transformer and create three output link based on the filtering criterion.

Thanks
Girija S

Add a row generater with three column Type INS Priority 2 and Count 0 After your aggr stage add a funnel and put these twwo link. After funnenl add remove duplicate based on Type and priority desc. If nothing comes from Aggr it has only one row, but if something coming from Aggr then it will take th...

Thanks Ray. I was just waiting for this statement.
You already mentioned earlier that they did lots of change in transformer in 7.5 and onwards.

Thanks again for your comment.

Girija S

Hi Sheema,

Try this.
Change the output table name. Load with create option.
And check whether Col5 created or not.

Just try it.

Thanks

As per I understand you get this error from input oracle stage, right?

Did you run "select col1, col2, col3, col4, decode(Col5,null,'A','B') col5
from Table1 " this query from "outside the datastage" ?.

Check it.

I hope you did this but just re-check.

Thanks

Hi All, In my job I am spliting the data based on some criterion and by using filter stage. I received the comment from the reviewer : "It is actually more efficient to use a transformer because the transformer is compiled and the filter is interpreted and adds more overhead than the transforme...

Sorry Craig ! I think it will make more sense now. parentlink seqfile----->Xmer------->OraEnterpStgforParent | / childlink | / reject link from oracle stage | / | / | / | / V V JoinStg (Required to restrict the childlink until parent finished) | | | V OraEnterpStgforChild

Sorry for late reply !!!!!!!!!!!!! parentlink seqfile----->Xmer------->OraEnterpStgforParent | | childlink | / |parentrejectlinkrom Oracle stage | / | / | / V V JoinStg (with sort restrict till parent finished) | | | V OraEnterpStgforChild Assuming that there should not be any data coming from paren...

Yes you can do this but it is tricky. First of all you need to ensure the parent population first and then child. 1. Use parent oracle stage write method as upsert 2. Parent oracle stage properties : Reject mode is true 3. Get reject link from that parent oracle stage and join with the input child l...

Hi,
As per my knowledge, you can't write NULL in sequential file. I think you mean trimmed values stored in sequential file and you want to pad spaces when you load into oracle table. If so try with field type as char with proper length and define APT_STRING_PAD_CHAR as 0x20.

Yes, this is right. Write a C/C++ code. Compile/build it and define here as Object (.o file) or Library (.dl / .sl)

What will be the max length of your input DESC?

Now I understand the probelm ( probably !!). I think you can partition by member id and sort by IC_DT (Desc) as input to your transformer. 1. Add one stag_var for mem id and defaulted to some value. 2. Add another stage var as date for stgEndDt, stgPrevEndDt 3. IF link.mem_id <> stgMemId then 12/31/...